Changing

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, MudGuard

Post Reply
mlarson
Posts: 2
Joined: Mon Nov 23, 2009 6:08 pm

Changing

Post 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
ben_josephs
Posts: 2464
Joined: Sun Mar 02, 2003 9:22 pm

Post 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
mlarson
Posts: 2
Joined: Mon Nov 23, 2009 6:08 pm

Post 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!
Post Reply