This tip is courtesy of BobK and was a response to a question I had of how to remove multiple non numeric characters from a text field that is acting as a numeric field (in this case a telephone number with various notational characters e.g. 1 (555) 333-1212 to get 155221212)
https://www.awareim.com/forum/viewtopic ... 352#p47352
Tip is that regex is your friend - a rather prickly friend who can be quite rude at times, but one you can call at 3am from the drunk tank.
Thanks BobK
REPLACE_PATTERN & Multiple Patterns
-
- Posts: 1462
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya