|
Mailing Lists
|
Home /
Groups /
Regular Expressions (RegEx)
How to clean a phone number with regex
I am very new to regex and I basically need to clean a phone number. I need all numbers entered to look like 5555555555. I am using REReplace(foo.foo, "[^0-9]", "", "ALL") and it is cleaning 555-555-5555 but not (555)444 4444. Any help would be greatly appreciated. THX > I am very new to regex and I basically need to clean a phone number. I need all numbers entered to look like 5555555555. I am using REReplace(foo.foo, "[^0-9]", "", "ALL") and it is cleaning 555-555-5555 but not (555)444 4444. There's no reason that shouldn't work. Doing rereplace(input,'[^0-9]','','all') will replace everything that is not 0123456789 with blank. You could also try doing rereplace(input,'\D','','all') which will have the same effect ( \D is the opposite of \d and \d is shorthand for [0-9] ). I suspect maybe some other part of your code is interfering with the results in some way.
|
May 22, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||