Omit Footer WhileLoading the Data using copy

San2

HI,

 

Iwant to omit the footer from my files while loading the data using Copy command

 

 

is there any way to omit

 

 

Can any one  help in the issue.

 

 

 

Thanks

 

San2

eli_revach

Hi
In linux environment , you would like to do something like this :

head -n -1 yourfile| vsql -c 'copy table (...) FROM STDIN'

I hope you will find it helpful

Thanks

 

Adrian_Oprea_1

Why dont you just remove all last lines from all the files you are about to load ! 

 

Use this snipet:

sed -i '$ d' *.csv