Unparsable Record for "Header" Row (1 Viewer)

I have a saved import that my office will be performing monthly (or more often). We pull a report from another system that comes out in a delimited text file. I prefer to keep the header row in the document - I don't want to force my personnel to remove the header row, but I also want the header row to be available in case we need to import it to Excel or provide it to other users - with no header row they may not be wise enough to figure out what some of the data details.

However I receive the "Unparsable Record" error currently when importing.

Is there a way to prevent the first row from importing to the table so we don't get an error table created?


Thanks all,

~Kit

When you are setting up your import process, the screen where you select the delimiter has a check box that the first row contains field names and if checked, the first row will not be imported.

Cronk said:

When you are setting up your import process, the screen where you select the delimiter has a check box that the first row contains field names and if checked, the first row will not be imported.

Click to expand...

That's what I thought too, but it doesn't want to work. :banghead:

kit_sune said:

That's what I thought too, but it doesn't want to work. :banghead:

Click to expand...

Ok, I feel dumb!

The report was printing an erroneous character at the very end that couldn't be imported.

Once I deleted this character from the text file it imported smoothly. Thanks.

~Kit