parsing a pesky txt file

CorCor

Hello - 

I DID find some help in the community - and tried a few solutions - but none of them worked quite right.

I am sure I need to use the "text to columns" tools a couple of times....but cant work it out.

Trying to put this into a table (obvs)

Is it the file itself and not having clean delimiters?

Thanks!

sm.data.4.Arkansas.txt

Emil_Kos

Hi @CorCor,

For me it works:

Output:

Please check my workflow maybe you have a different configuration.

If this was helpful for you please mark my post as a solution!

Delimeter.yxmd