Re: LTRIM Function (URGENT)
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 12 Jul 1999 21:48:21 +0800
Message-ID: <3789F225.7670_at_yahoo.com>
Date: Mon, 12 Jul 1999 21:48:21 +0800
Message-ID: <3789F225.7670_at_yahoo.com>
Tay, Virginia wrote:
>
> Hi,
> I would like to trim the following field to be R-13935-01.....Is that a way
> that get rid of the first 32 characters (First 8 numbers + 24 spaces) by
> using LTRIM function....
>
> DOCUMENTNO
> ===========
> 00003331 R-13935-01
>
> Please help! THIS IS URGENT!
>
> Thanks a lot!
>
> Virginia
What is wrong with SUBSTR ?
x := substr(documentno,33)
will get all characters from 33 onwards...
If you don't know where the "R-" appears, then you use INSTR
x := substr(documentno, instr(documentno, 'R-'));
HTH
-- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com "Some days you're the pigeon, and some days you're the statue."Received on Mon Jul 12 1999 - 15:48:21 CEST