Re: need to trim spaces from sqlplus output

um tried that. Couldn't find info applicable to the situation.  The Oracle
trim command doesnt work in that situation.  However, the sed command does
what is needed.

While a true sed guru can probably do this without the interim pipe, this
does what I needed.  I was using the | as the delimiter in the file also:

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




On Tue, Jan 18, 2011 at 3:17 PM, David Barbour <david.barbour1@xxxxxxxxx>wrote:

> Uh............ try Google?  (Hint: look for "Oracle" + "trim")
>
>
> On Tue, Jan 18, 2011 at 2:45 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
>
>> 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
>>>>
>>>> --
>>>> http://www.freelists.org/webpage/oracle-l
>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>


-- 
Andrew W. Kerber

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

Other related posts: