Page 1 of 1

Changing

Posted: Mon Nov 23, 2009 6:20 pm
by mlarson
I have a phone number addressbook data that was exported to me as in below:

110 123 1234|more data etc
112 123 3563|more data etc
444 123 2349|more data etc
etc...

I need to change the data so that the phone number which is the first field does not have spaces - I need it to look like this:

1101231234|more data etc
1121233563|more data etc
4441232349|more data etc
etc...

I tried other packages and was unable to do it - I think Textpad can do it but I dont know how to do it since I just purchased it - So I need very specific instructions on how to do it.

Thanks!
Matt

Posted: Mon Nov 23, 2009 10:44 pm
by ben_josephs
Find what: ^([0-9]+) ([0-9]+) ([0-9]+)
Replace with: \1\2\3

[X] Regular expression

Replace All
This assumes you are using Posix regular expression syntax:
Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

Posted: Wed Nov 25, 2009 3:01 pm
by mlarson
ben_josephs wrote:
Find what: ^([0-9]+) ([0-9]+) ([0-9]+)
Replace with: \1\2\3

[X] Regular expression

Replace All
This assumes you are using Posix regular expression syntax:
Configure | Preferences | Editor

[X] Use POSIX regular expression syntax
**** This worked like a champ! ****
Thanks very much!