Skip first few lines in a csv file

[#1]

Morning all,

Is there a way i can import a csv file but skip the first few lines? I have a bunch of info I don't need in the first row.

Thanks,

Tony

[#2]

Hi

You can use a where clause.

If it does not have anything to differentiate the data you want returned and th data that you don't want returned, add a field to the csv file, do the where clause on there.

Hopes this helps.

[gandalfgray]

Use the "header is" clause of the Load-statement:

LOAD @1,
@2
FROM
S:\QVApps\wherever\whatever\alittlefile.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq, header is 3 lines);

Or in the File wizard:

Set the figure to whatever number of lines you have of course... I just used 3 as an example here

[#4]

Thanks Goran, that's just what I was after.

Tony