You are here:  » Removing the first line from a CSV file


Removing the first line from a CSV file

Submitted by baggagepin on Wed, 2013-03-20 11:31 in

Hi,

I have a CSV file which has a header which contains a string like this:

" "," ","One"," ","Two","Three"," "," "," "

Do you know of any way I can remove this line before I pass the file through the Parser.

Many thanks for any pointers and help you could provide.

Cheers,

Dereck

Submitted by support on Wed, 2013-03-20 11:39

Hello Derek,

Sure - there is an option 4th component to the CSV Format String that contains a number of rows to skip. For example, if you are currently using

csv|44|0|34 (comma separated, no header row, quoted text)

...then you would use:

csv|44|0|34|1

..to skip 1 line at the start...

Hope this helps!
Cheers,
David
--
MagicParser.com

Submitted by baggagepin on Wed, 2013-03-20 12:04

Hi David,

Many thanks for such a fast reply.

So easy when you know how.

Again many thanks,

Cheers,

Dereck