Page 1 of 1

Newbie Questions: Fixed length file

PostPosted: Tue Dec 21, 2010 7:34 pm
by pbastian
I'm working with the demo version to create some maps. One of my data sources is a multi-record-type fixed-length text file.
While I have some questions about the most efficient way to map the different record types into separate files, my more important question has to do with parsing out the columns.

    Column1 - 17-char string (always populated)
    Column2 - 6-char string (always populated)
    Column3 - 50-char string (only populated in some cases. In others, the field is 50 spaces)
    Column4 - 15-char string (always populated)

In importing the file, DataSlave moves the text from Column4 into Column3 if Column3 contains only spaces, which throws the parsing off.

Is there an option or preference to eliminate this action? I feel like the solution is probably very obvious, but I haven't found it.

Thanks very much.

Re: Newbie Questions: Fixed length file

PostPosted: Wed Dec 22, 2010 2:55 pm
by pbastian
Never mind: issue is resolved.