
drothman66
Novice
Mar 5, 2010, 9:54 AM
Post #7 of 10
(18616 views)
|
Re: [shawnhcorey] "123 456" to "123456"
[In reply to]
|
Can't Post
|
|
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.... 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. thanks again
|