Re: HOWDOI: Output Variable Length Fields (Re: rtrim not triming)
From: Mike Neal <mike.neal_at_acms.avnet.com>
Date: 1997/01/23
Message-ID: <01bc095e$fdf1f680$0681180a_at_mneal.ims.avnet.com>#1/1
Date: 1997/01/23
Message-ID: <01bc095e$fdf1f680$0681180a_at_mneal.ims.avnet.com>#1/1
Use:
update table_name
set field1 = rtrim(field1, ' ')
and then repeat for the other fields, this should chop off the trailing
spaces
Eric M. Gamble <emgamble_at_rwxc.com> wrote in article
<01bc0910$43ec0800$a5b093cf_at_egamble>...
> I have tried everything from RTRIM to selecting the SUBSTR of the LENGTH
to
> achieve the following output:
>
> 10~FIELD2~~SOME TEXT
> 101~FIELD2~EXTRA INFO~SOME MORE TEXT
> 1~FIELD2~INFO~LITTLE TEXT
>
> I keep getting:
>
> 10 FIELD2 SOME TEXT
> 101 FIELD2 EXTRA INFO SOME MORE TEXT
> 1 FIELD2 INFO LITTLE TEXT
>
> I do not what fixed length records. I need variable length records. How
> do I do this?
>
>
Received on Thu Jan 23 1997 - 00:00:00 CET