Re: HOWDOI: Output Variable Length Fields (Re: rtrim not triming)
From: OraSaurus <granaman_at_mail.phonet.com>
Date: 1997/01/31
Message-ID: <5crsc2$if1_at_iorich.phonet.com>#1/1
Date: 1997/01/31
Message-ID: <5crsc2$if1_at_iorich.phonet.com>#1/1
In article <01bc0910$43ec0800$a5b093cf_at_egamble>,
"Eric M. Gamble" <emgamble_at_rwxc.com> wrote:
>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?
Select field1 || '~' || field2 || '~' || ... from whatever; Received on Fri Jan 31 1997 - 00:00:00 CET