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
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.