Creating rows and columns from a raw txt file

Question

I will continue to work on this but wanted to see if anyone can offer assistance!

As always, your help is appreciated!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 attempted:

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

mbarone · Answer

Hi @mzsweetumz , for your best chance at getting help on this one, you should post it in the Designer Discussions board (pretty much any questions having to do with building or troubleshooting workflows would go there).

It's hard to tell exactly how to figure this one out (at least for me it is), but it appears that your input is good (having it as csv with a \0 delimiter) but I would uncheck option 6 (first row contains field names).  Usually you'd have to read in all text as data (not headers) and then parse out your headers from there.  Is there some snippet of the data that is generic enough that you can post?  I'm by no means an expert in json parsing, but if I had a sample I might be able to help.