Mar 5, 2010, 9:54 AM
Post #7 of 10
not only does that work, it works for all the cases i can think of (when i add the g switch). this is great..thanks....
Re: [shawnhcorey] "123 456" to "123456"
[In reply to]
my purpose, by the way, is to clean up poorly entered phone numbers that i'm am sucking in directly from a series of Excel spreadsheets.
i simply want to grab the numbers and eliminate "()\c-" (which i can simply do sequentially with your idiom). When they're imported back into excel, excel can format them correctly.
as i'm grabbing records as strings and dumping them to a .csv, i needed something which would work on more than just one field.