Replacement Value: --BLANK-- (just press the + in the Replacement value to get the BLANK value) Value to match on:\D
But RE did not apply the phone number formatting set up
I got 416--BLANK--416--BLANK--4416
Please help, Many thanks, Sandra
almost 9 years ago
Delete the entry by highlighting the --BLANK-- and hitting delete on your keyboard.
Then place your cursor in the Replacement Values box, and hit Enter. This will give you an entry for -- BLANK -- (by just pressing Enter or the + button, you'll get the entry with the spaces). Now you can add the Values to Match on of \D.
Remember to check the box to "Use Regular Expressions".
Please let me know if it's still not translating properly.