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

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

thanks. This is the best 1 liner solution.


>From: "Larry Roux" <LRoux@syr.edu>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Dealing with phone numbers in sqr
>Date: Thu, 29 May 2003 14:11:36 -0400
>
>I believe that you can use the translate function
>ie
>Let $TRANS_PHONE = translate($phone,'() -','')
>
>This should remove all extra characters
>
>
>
>******************************
>Larry Roux
>Syracuse University
>lroux@syr.edu
>*******************************
>
> >>> ashish_bhatt@hotmail.com 05/29/03 02:04PM >>>
>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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ at 
only S$36 including GST

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