Re: need to trim spaces from sqlplus output
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: michaeljmoore@xxxxxxxxx
- Date: Tue, 18 Jan 2011 14:45:38 -0600
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@xxxxxxxxx>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@xxxxxxxxx>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
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
