RE: [sqr-users] Dealing with phone numbers in sqr

[skirklin@stl-inc.com]

You could use the string function called replace and replace the "(" with a
null. You could do it again for the "-". Not sure if this will work.

Or you could extract parts of the phone number into variables using the
substr command and then concatenate the variables back together

phone1 = substr(phone,2,3)
phone2=substr(phone,7,3)
phone3=substr(phone,11,4)

phone = phone1 || phone2 || phone3


Sherri Kirklin
Analyst/Programmer
STL-Austin
Ph: (512) 310-5286
Fax: (512) 244-0160
skirklin@stl-inc.com


-----Original Message-----
From: Ashish Bhatt [mailto:ashish_bhatt@hotmail.com]
Sent: Thursday, May 29, 2003 1:04 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Dealing with phone numbers in sqr


Hi All SQR Gurus,

I hope you are doing fine today.

I am writing a sqr in which I need to give the user the phone numbers 10 
digits in the format 9999999999.

My problem is that I have the phone numbers as (123)-456-7890 or 
123-456-7890. How to convert these to 1234567890 ?

Has anyone done this before in SQR ?

If yes, please share with me.

Thanks in advance.

Have a nice day and great week.

Regards.

Ashish Bhatt.

_________________________________________________________________
Find gifts, buy online with MSN Shopping. http://shopping.msn.com.sg/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



Confidentiality Notice: The information contained in this message is
intended only for the use of the addressee, and may be confidential
and/or privileged. If the reader of this message is not the intended
recipient, or the employee or agent responsible to deliver it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify the
sender immediately.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users