You can use this dictionary:
Replacement Value: --BLANK-- (just press the + in the Replacement value to get the BLANK value)
Value to match on: \D
This removes from the string anything that is not a number.
Then RE will apply the phone number formatting set up in your phone types table.
Please let me know if you have any questions!
Did you check the "Use Regular Expressions" checkbox? Following Amanda's suggestion worked on my machine:
It works. Thank you.
Does anybody know how to translate postal code from M8V2E7 to M8V 2E7? Adding space.
This will look for a format of letter number letter number letter number, just in case you have other zip codes for other countries.
Don't forget to check the "Use regular expressions" checkbox. Please let me know if you have any questions!
The string isn't being split into the two pieces as it is below?