Multiple file import : skip last {n} lines or skip line starting with



While the skip header lines is great, I would hope to see the skip {n} last lines also.

I have a fixed length text file, where each record/line is 903 characters, but there is a "closure" line to reflect the number of records in the file. This line has a different length and causes the import to fail the file.

This line starts is like

*** last record after 12503 records ***

(yes, coming from an old mainframe ;-)

I have tried to specify the ** as header line, and use skip 1 header line, but it seems the import does not like this (seems to hang up the import process completely)


Please sign in to leave a comment.