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.
HiIn 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
Why dont you just remove all last lines from all the files you are about to load !
Use this snipet:
sed -i '$ d' *.csv