Re: [Arsperl-users] OT: sqlplus question

[Ron T. <ron...@ut...>]

Just figured out my problem.  I was missing a || in my select
statement.  It formats fine now.

Thanks
Ron

Ron Tyro wrote:
> 
> 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
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users