How can we help you today?
Using regex to translate phone #
17 CommentsSorted by Oldest First
I tried to use the dictionary:
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
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
Hi Sandra,
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.
Thank you,
Amanda
Omatic Support
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.
Thank you,
Amanda
Omatic Support
Hi Amanda,
I got it, it works. Thank you Amanda.
Sandra
Catherine Han