I have an issue with an export since the phone numbers from the database are all over the place. Meaning some are entered like "(123) 465-7891" while others are like "1234567891" and others are like "123-456-7891".

What I have is a formula to remove everything from the phone number so that it's just straight numbers and then use code to format the field but, it's not working. Here is my formula.

Shared StringVar hPhone = "";
hPhone := Replace(Replace(Replace({Table.homePhone}, "(", ""), ")", ""), "-", "");

hPhone := Picture (CStr (hPhone), "(xxx)xxx-xxxx");

what i want is (123) 456-7891 and what I'm getting is (123) 45-67891. any clue what I'm doing incorrectly?