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

--
http://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