LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

I get a textfile every week which i read in as a delimited file.
The first 5 rows in the file are just jiberish data, and the header starts at row 6.

Is there a way to start the reading form the 6th row?

Like the XMLmapping in the excel node..

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

There is no option on the delimited file node to do something like this.
I think your best option is either:

• Read in the delimited data with 1 line per record
• Remove the junk records
• Write this out to a temporary file with only the "real" delimited data
• Read in the "real" delimited data

Or, you could follow the first two steps above, then rather than write to file, split out the delimited content using a Expand from List node, and use a Pivot - Data to Names node to ensure that the delimited data shows up correctly under the correct headers.

An example of the second approach is attached.
I've configured the composite a little so you can just specify the number of header lines and trailer lines to be skipped along with the field and record delimiters for the "real" delimited data.


Hope this helps.

Tim.
Attachments:
DelimitedFileWithJunk.brg