Text to columns (add header)

[tiverson]

I have a crazy text file that I need to parse out and create consistent columns.  

My file does not have a header row, but I know what it needs to be:

How can I add the header column titles and parse out the file into columns (based on a fixed width)

Text file:

I need to add the following column titles (plus number of characters)

System - 3

Posting Date - 8

Doc Date - 8

Account - 10

Text - 50

Amount = 13

There are a lot more I need to add and the files I have are huge, but if I could get an example of the above items I believe I can finish up the rest.

Thanks,

Todd

[Felipe_Ribeir0 · Accepted solution]

Hi @tiverson 

The best way here is to input this file as a flat file - delimited text