DSXchange

Hi ,
I have to read the phone number from the data and find if there are any special charaters. If so then I need it to default it depending on the special characters. Phone number in the data is displayed as "xxx-xxx-xxxx". Can you please guide how to implement the logic to read the entire phone number and default it rather than checking the area code, phone number separately .

Ex: 123-*&^-1234 or @#$-123-1234 . It should read the entire phone number and default it instead of implementing logic for area code and number separatley .

If the hyphens are always present, then something like Num(Convert("-","",InLink.Telephone)) should suffice as the test expression in an If..Then..Else construct.

Or maybe Len(Convert("0123456789-","",InLink.Telephone))

You Can Use NUM function

Sampath wrote:You Can Use NUM function

Oh. Did I not mention that one? Oh.

Thanks for you help...