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.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
