Text (.txt) file Non-Delimited - Flat File Layout

I have a text file that I need to separate into about 250 columns. There are no delimiters that exist. (see pic below)

Text File example.png

Is there a way to establish the field names/lengths outside of manually setting the field divisions and naming each field? I see the "Use Field Settings from File" option, but can't locate any instructions/examples on how that is used.

Ideally, I'd like to create a file with the field name and lengths and then use those values to parse the txt file.

Input

Accepted answers

MarqueeCrew

I've used this technique in the past:

open your file and create 2 or 3 fields.

Save you file as a FLAT

Open the FLAT and you'll see the XML that you need.

Create a formula that concatenates all of the data together based upon a table of fields and lengths.

Update your xml and save. When you open the flat file, use the .FLAT as the metadata.

Done.

All comments

MarqueeCrew

I've used this technique in the past:

open your file and create 2 or 3 fields.

Save you file as a FLAT

Open the FLAT and you'll see the XML that you need.

Create a formula that concatenates all of the data together based upon a table of fields and lengths.

Update your xml and save. When you open the flat file, use the .FLAT as the metadata.

Done.

wottel

Thanks so much Marquee.. that saved me a ton of time and tedious work..

UnknownUser

Is it possible to provide the Alteryx workflow for this?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703