Omit Footer WhileLoading the Data using copy

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

+2

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

+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

Sign up