INSTR challenge
From: Jenny Farnham <farnham_at_spot.colorado.edu>
Date: 21 Feb 2001 22:48:16 GMT
Message-ID: <971gjg$885$1_at_peabody.colorado.edu>
Date: 21 Feb 2001 22:48:16 GMT
Message-ID: <971gjg$885$1_at_peabody.colorado.edu>
[Quoted] [Quoted] I have a character field that holds something like this:
[Quoted] 12345,678,123
The comma is like a delimeter.
So, ultimately I'd like to pull out
12345 and 678 and 123
I know INSTR will return the location of the commas and I could use sustr to help, but how do I get all 3 numbers to be pulled out?
Thanks,
Jen
Received on Wed Feb 21 2001 - 23:48:16 CET