[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: phone number format -Reply



This is the first thing that came to mind.  It's not as foolproof as Davids
approach but it is much less code.
                                                            1     2

        let $phone2=translate(&phone,' +/\|-_','')

Where '1' are the characters you want to screen out and '2' is a null.  Like
I said its not foolproof but its simple.

HTH
John Milardovic
> -----Original Message-----
> From: David Anderson [SMTP:DANDERS1@SMTPGW.IS.HFH.EDU]
> Sent: Wednesday, June 23, 1999 5:29 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      phone number format -Reply
>
> This isn't an elegant approach, but you could scan through
> the source variable one character at a time.  Test if the
> character is a number.  If true, concat the character to your
> target variable.