You are here:  » Remove headers in feed file

Support Forum



Remove headers in feed file

Submitted by toeknee on Sun, 2007-12-30 21:01 in

I have a feed file with the following format:

#HEADER#
Version : 3
EOF : '|'
EOR : '~'
#DEFINITION#
AGENT_REF|ADDRESS_1|etc
#DATA#
blah|blah|etc

It works with PT if I remove the first seven lines, but was wondering if it is possible to do this automatically or could someone point me in the right direction for writing a script to do this?

Help most appreciated

Tony

Submitted by support on Sun, 2007-12-30 21:06

Hi Tony,

Yes - you can use a "hidden feature" of the parser to deal with this. When you click "Register", you should get an auto-detected "Format String" displayed in the box, for example:

csv|124|0|0

(plain text, pipe separated, no-header row, no text-delimiters)

Now, you can add a 4th number to the format to specify the number of lines of header to skip, so in your case you can manually enter the following format string (or similar) to handle this automatically:

csv|124|0|0|7

Hope this helps!
Cheers,
David.

Submitted by toeknee on Sun, 2007-12-30 21:12

That's great thanks a lot.

Cheers,

Tony