Re: need to trim spaces from sqlplus output

Well, the trouble is I do actually need a delimiter there, I am using set
colsep '|' so I have a pipe delimiter.  If there was a way to trim the data
before the column separator it would be nice, but I couldnt figure out any
way to do it.  I ended up using a sed command to trim the resulting output
that seems to work.

sed 's# *|#|#g' infile.csv | sed 's/|[ ]*/|/g' > output.txt

Probably a real sed guru wouldnt need the pipe, and no doubt a perl guy
would laugh at this, but it gets the job done for a guy whose primary
Unix/Linux experience comes from having to figure stuff out from the dba
point of view.



On Wed, Jan 19, 2011 at 10:13 AM, <Joel.Patterson@xxxxxxxxxxx> wrote:

> I like it, should be a lot faster.  I wonder what Andrew says.
>
> Even if it is unix, we are still using Sqlplus eh?
>
> Also the login.sql idea could be handy by Howard.
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Dunbar, Norman (Capgemini)
> Sent: Wednesday, January 19, 2011 3:06 AM
> To: andrew.kerber@xxxxxxxxx
> Cc: oracle-l
> Subject: RE: need to trim spaces from sqlplus output
>
> Morning all,
>
> try set colsep "" (two double quotes, nothing in between). The default
> is set colsep " " (one space).
>
>
> SQL> -- Default - one space.
> SQL> select dummy,dummy from dual;
>
> D D
> - -
> X X
>
> SQL> -- Underscore.
> SQL> set colsep _
> SQL> /
>
> D_D
> -_-
> X_X
>
> SQL> -- Nothing, just as nature intended!
> SQL> set colsep ""
> SQL> /
>
> DD
> --
> XX
>
>
> Cheers,
> Norm.
>
> Norman Dunbar
> Contract Senior Oracle DBA
> Capgemini Database Team (EA)
> Internal : 7 28 2051
> External : 0113 231 2051
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for litigation.
>  Email messages and attachments sent to or from any Environment Agency
> address may also be accessed by someone other than the sender or recipient,
> for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506.  Find
> out more about the Environment Agency at www.environment-agency.gov.uk
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: