Newbie Questions: Fixed length file

Support for DataSlave

Moderators: Tom, ian

Newbie Questions: Fixed length file

Postby pbastian » Tue Dec 21, 2010 7:34 pm

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.
pbastian
 
Posts: 2
Joined: Thu Dec 16, 2010 1:33 pm

Re: Newbie Questions: Fixed length file

Postby pbastian » Wed Dec 22, 2010 2:55 pm

Never mind: issue is resolved.
pbastian
 
Posts: 2
Joined: Thu Dec 16, 2010 1:33 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron