let Source = Xml.Tables(Web.Contents("https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000789019&type=&dateb=&owner=exclude&start=0&count=40&output=atom")), #"Changed Type" = Table.TransformColumnTypes(Source,{{"id", type text}, {"title", type text}, {"updated", type datetimezone}}), entry = #"Changed Type"{0}[entry], #"Split Column by Delimiter" = Table.SplitColumn(entry, "id", Splitter.SplitTextByDelimiter("=", QuoteStyle.Csv), {"id.1", "id.2"}), #"Removed Columns1" = Table.RemoveColumns(#"Split Column by Delimiter",{"id.1", "title"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"id.2", "SEC Accession No."}}), #"Duplicated Column1" = Table.DuplicateColumn(#"Renamed Columns", "SEC Accession No.", "SEC Accession No. - Copy"), #"Replaced Value" = Table.ReplaceValue(#"Duplicated Column1","-","",Replacer.ReplaceText,{"SEC Accession No."}), #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Replaced Value", {{"SEC Accession No. - Copy", each Text.BeforeDelimiter(_, "-"), type text}}), #"Trimmed Text" = Table.TransformColumns(#"Extracted Text Before Delimiter",{{"SEC Accession No. - Copy", each Text.TrimStart(_,"0"), type text}}), #"Expanded content" = Table.ExpandTableColumn(#"Trimmed Text", "content", {"Attribute:type", "filing-type", "form-name", "xbrl_href"}, {"Attribute:type", "filing-type", "form-name", "xbrl_href"}), #"Filtered Rows" = Table.SelectRows(#"Expanded content", each ([xbrl_href] <> null)), #"Split Column by Position" = Table.SplitColumn(#"Filtered Rows", "updated", Splitter.SplitTextByPositions({0, 10}, false), {"updated.1", "updated.2"}), #"Duplicated Column" = Table.DuplicateColumn(#"Split Column by Position", "updated.1", "updated.1 - Copy"), #"Renamed Columns2" = Table.RenameColumns(#"Duplicated Column",{{"updated.1 - Copy", "html Date"}, {"SEC Accession No. - Copy", "CIK"}}), #"Replaced Value1" = Table.ReplaceValue(#"Renamed Columns2","-","",Replacer.ReplaceText,{"html Date"}), #"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value1",{{"updated.1", type date}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"updated.2"}), #"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"updated.1", "Filing Date"}}), #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Filing Date", "filing-type", "form-name", "CIK", "SEC Accession No.", "html Date", "category", "xbrl_href", "link", "summary"}) in #"Reordered Columns"