Hi,
This is a little off topic, but maybe someone has done this before and
can help me out.
I'm attempting to use sqlplus to create a csv file, and it works fine,
expect for one problem:
"id" ,"number" ,"firstname lastname"
,"0" ,"the rest"
There are spaces between each field which I would like to remove so that
it looks like:
"id","number","firstname lastname","0","the rest"
Does anybody know how to make this work in sqlplus? I tried to remove
the blanks with the following command:
cat input.csv | tr -d " " > input2.csv
but it removes all the blanks, even those I would like to keep (like
firstname lastname)
Any suggestions would be appreciated!
Thanks,
Ron
Scotiabank Information Commmons, University of Toronto
|
