Re: need to trim spaces from sqlplus output

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 18 Jan 2011 14:45:38 -0600
Message-ID: <AANLkTikX6sShyDAEf1QBW5wp-3_dxgZJnxUW_4O1AC14_at_mail.gmail.com>

Yeah, its a matter of time. If I can just fix the output files with some simple commands its easy. To do it the other way, I have to go and modify 32 separate queries.

On Tue, Jan 18, 2011 at 1:40 PM, Michael Moore <michaeljmoore_at_gmail.com>wrote:

> select last name||'|'||first_name from ... etc
>
> In other words, avoid the problem in the first place. This might not be an
> option for you.
>
> Mike
>
> On Tue, Jan 18, 2011 at 9:02 AM, Radoulov, Dimitre <cichomitiko_at_gmail.com>wrote:
>
>> On 18/01/2011 17:50, Andrew Kerber wrote:
>>
>>> Does anyone have a unix script to trim spaces prior to the column
>>> separators 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
>>
>>
>>
>

-- 
Andrew W. Kerber

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

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

Received on Tue Jan 18 2011 - 14:45:38 CST