Create spreadsheet from raw txt file

[mzsweetumz]

Hello all,

I am trying to create a spreadsheet with a raw txt file and I was following the directions on a website but can't seem to figure it out.

Here is an example workflow I attempte

Notice the raw text in the field I circled above? I want to convert that text into a spreadsheet like so:

As always, your help is deeply appreciated.

[apathetichell]

This is similar. It includes the multi-formula to make ID into a counter and I split up the different JSON types for variable consistency.

[mzsweetumz]

Thank you so much Luke!! This workflow helped me tremendously and was able to get me exactly what I needed.

Very much appreciate your help with this.

[mzsweetumz]

Thank you so much!!

[mzsweetumz]

Hi @Luke_C  and @apathetichell ,

I am having trouble parsing another txt file into rows and columns. This time the data looks like xml format but is a txt file. The workflow that you provided helped with my other txt file, but does not apply the same logic to this one. I tried doing it a different way but cannot seem to figure it out.

I attached the sample data here: xml version.doc (for some reason it is not allowing me to upload txt files at the moment)

[Luke_C]

Hi @mzsweetumz 

Yes, XML would be handled differently than JSON. I don't have much experience dealing with XML files, however there is a specific XML parse tool and 2 weekly challenges that might help show you what you need to do. 

https://help.alteryx.com/20214/designer/xml-parse-tool

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-37-Parsing-a-Raw-XML-File/td-p/36577

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-195-XML-Parsing/td-p/505892

[mzsweetumz]

Thank you so much @Luke_C , I'll look into those!!!