How to remove the first row of a file 1

[LadyDragon]

Hi! I have another question about file manipulation on unix. I have a Korn shell script which uses sqlloader to load a .csv file. There is a header on the file which I do not want to load. How can I either strip the first line from the file prior to loading, or does sqlloader have a way to specify loading to start on line two?

Thanks!
Juls

 

[feherke]

Hi

Want to modify the file too, or just skip the first line when reading ?

sed '1d' file
[gray]# or[/gray]
tail +2 file

Feherke.

http://rootshell.be/~feherke/

 

[LadyDragon]

Thanks! That worked beautifully! :-D

Juls

 

[LadyDragon]

FYI for others trying the same thing...
I found another way to skip the first row for a file loaded via sql*loader: add the following line prior to the
LOAD DATA line:

OPTIONS (SKIP=1)
LOAD DATA
...