[RBASE-L] - Re: SRPL - Razzak's Reply

[J BLAUSTEIN]

this may work if you know what position the character is - I would like to 
be able to use "null" with the command
J

At 10:21 AM 6/20/2003 -0400, you wrote:
At 08:14 AM 6/20/2003 -0600, Troy Sosamon wrote:

Has anyone figured out how to use SRPL to not only remove a character,
but the spact too. I need a function that will strip the dashes out of phone
numbers.
123-4567 needs to come back 1234567.

I can loop through and process on character at a time, but I would really
like to be able to get the results in a select w/o having to do that.
Troy,

If the format is always the same, then:

UPDATE TableName SET PhoneNo = ((SGET(PhoneNo,3,1))+(SGET(PhoneNo,4,5)))

Have Fun!

Very Best R:egards,

Razzak.