Thanks Razzak
Wow, that is so simple, I guess I was trying to make it too hard
Marc
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, February 09, 2007 10:57 AM
Subject: [RBASE-L] - Re: Can you insert a blank space in text?
At 11:40 AM 2/9/2007, Marc Schluter wrote:
So, how do you update the phone numbers to add the proper spaces?
And if some of the numbers are 3352244 without the 918 would that
mess things up?
Marc,
Here's how:
Example:
-- Start
SET VAR v1 TEXT = '9183351555'
SET VAR v2 TEXT = +
((SGET(.v1,3,1))&+(SGET(.v1,3,4))&+(SGET(.v1,4,7)))
RETURN
-- End
Keeping that logic in mind, you may update the actual table as following:
UPDATE tablename SET phonecolname = +
((SGET(phonecolname,3,1))&+(SGET(phonecolname,3,4))&+(SGET(phonecolname,4,7)))
That's all there is to it!
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
