Re: need to trim spaces from sqlplus output

From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
To: andrew.kerber@xxxxxxxxx
Date: Tue, 18 Jan 2011 18:02:24 +0100

On 18/01/2011 17:50, Andrew Kerber wrote:

Does anyone have a unix script to trim spaces prior to the columnseparators in sqlplus output, ie, I have output like his:
LAST NAME |FIRST NAME  |BIRTHDAY
Kerber          |Andrew           |Aug01

That I want to look like this:

LAST NAME|FIRST NAME|BIRTHDAY
Kerber|Andrew|Aug01



sed 's# *|#|#g' infile



Regards
Dimitre

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: need to trim spaces from sqlplus output
  - From: Michael Moore

References:
- need to trim spaces from sqlplus output
  - From: Andrew Kerber

Other related posts:

» need to trim spaces from sqlplus output- Andrew Kerber
» RE: need to trim spaces from sqlplus output- Allen, Brandon
» Re: need to trim spaces from sqlplus output - Radoulov, Dimitre
» Re: need to trim spaces from sqlplus output- Michael Moore
» Re: need to trim spaces from sqlplus output- Andrew Kerber
» Re: need to trim spaces from sqlplus output- David Barbour
» Re: need to trim spaces from sqlplus output- Andrew Kerber
» RE: need to trim spaces from sqlplus output- Dunbar, Norman (Capgemini)
» RE: need to trim spaces from sqlplus output- Dunbar, Norman (Capgemini)
» Re: need to trim spaces from sqlplus output- Howard Latham
» RE: need to trim spaces from sqlplus output- Joel.Patterson
» Re: need to trim spaces from sqlplus output- Andrew Kerber
» RE: need to trim spaces from sqlplus output- Dunbar, Norman (Capgemini)
» Re: need to trim spaces from sqlplus output- Jared Still
» Re: need to trim spaces from sqlplus output- De DBA
» Re: need to trim spaces from sqlplus output- Andrew Kerber