split into rows

[rootsmusic]

My query connected to a .txt file, which has the following line:

elections_to_vest_changes = {'119WEST BUFFALO': '119000210WEST BUFFALO', '119UNION': '119000200UNION', '119NEW BERLIN': '119000190NEW BERLIN'}

The single quotation marks enclose text.  The colon is a delimiter for a column.  The comma is a delimiter for a row.

(I've shortened this line for readability.)  How can I split this line by delimiter into rows?  Thanks.

[Anonymous]

Save your text in a json file, transforming '(single quote) into "(double quote) and use the following script to transform it into a table with two columns and many rows

let
    Source = Json.Document(File.Contents("C:\Users\sprmn\OneDrive\Documents\Power BI Desktop\test.json")),
    tfc=Table.FromColumns({Record.FieldNames(Source{0}),Record.FieldValues(Source{0})})
in
    tfc

[serpiva64 · Accepted solution]

Hi,

if something like this is what you need

you have first to split by delimiter in rows

then split by delimiter in columns

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !