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

TRANSLATE function

Has anyone had any luck in stripping off non-numerical characters from phone numbers?

I have a phone number field that "normally" looks like ###/###-#### and needs to be an all numerical field.  Normally, I would do
LET $phonenbr = TRANSLATE($phone_nbr,'/','')
LET $phonenbr = TRANSLATE($phone_nbr,'-','')

This seems like a roughneck way of coding and does not take into consideration any other code that might slip through.

Sam