Re: phone number format

["Logu Chakravarthi (IT Dept. - Langley)" <logu_chakravarthi@OWFG.COM>]

The translate function will be a better approach to handle this .
begin-procedure assign-var
 let $tele_num1 = '612/ 706-0339'
 do translate-var
 let $tele_num1 =  '33 25 66 988 2334'
 do translate-var
end-procedure

begin-procedure translate-var
 let $new_num1 = translate($tele_num1,'-/,', '')
 let $new_num1 = translate($new_num1,' ', '')
 display $new_num1
end-procedure

I just tried and see.

c.Logu

> -----Original Message-----
> From: Buchanan, Timothy [SMTP:buchanan@BIPERF.COM]
> Sent: 1999/06/23 1:27 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      phone number format
>
> Any easy way to take phone number data from a table such as:
>
> 612-777-9965
> 6127813323
> 33 25 66 988 2334
> 612/758/9967
> 612/ 706-0339
>
>
> and parse it out into just the phone number like this:
>
> 6127779965
> 6127813323
> 3325669882
> 6127589967
> 6127060339
>
>
> ????
>
>
>  Thanks in advance...
>
>  Timm