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