Find and Replace

[kjxavier]

How will i Find and insert a <space> after 9th anycharacter in Find and Replace Box.

Example1: (402) 551-394139 with (402) 551-3941 39 ;
Example2: (650) 589-678899 with (650) 589-6788 99

after the closing bracket i have a space followed by any 3 digits, a hyphen and I need a space after 4 digits

[macropod]

Hi kjxavier,

Try a wildcard Find/Replace, where:
Find = ([0-9]{3}-[0-9]{4})([0-9]{2})
replace = \1 \2

[kjxavier]

Yup, That helped a lot.

thanx Mr. Paul Edstein

[kjxavier]

Dat helped me....

Can i have "DOUBLE SPACE" after the .com , .org , .biz or any three characters after the DOT of any E-mail Address.
So that i can Replace my Double Spaces to Tab Character and take it to another field in my XL sheet.

Example1: rawls@msn.comSAN DIEGO to rawls@msn.com SAN DIEGO
Example2: paulgirard@optonline.netsanta rosa to
paulgirard@optonline.net santa rosa


I just need 2 spaces after any three Characters after the DOT in only email address fields. (there are many dots in the line other than email) somethng like @ followed by a DOT(.)



xavier

[macropod]

Hi xavier,

Try a wildcard Find/Replace, where:
Find = ([! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])
Replace = \1 \2
However, if you've also got email addresses like 'paulgirard@optonline.net.au' merged with other text (eg 'paulgirard@optonline.net.auSYDNEY'), a separate wildcard Find/Replace operation will be required for them, where:
Find = ([! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3}.[a-zA-Z]{2})([!. ])
Replace = \1 \2

[kjxavier]

it worked at one place ... but for some other lines it didn't.
Find[! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])
Replace with: \1 \2

For Example: ognjanovic@collegeclub.comA -changed to- ognjanovic@collegeclub.com A (perfect)

but not for these lines:
oni@optonline.netPortage
pollonais@collegeclub.comPALM
pappyjump@aol.com HoustonTX (where single space is already there)
orit.moalem@adttsa.com Petaluma
randall.e@aug.comGlen
otutmaz@aol.comElmhurst

[kjxavier]

When this stands alone it works
oni@optonline.netPortage
pollonais@collegeclub.comPALM
randall.e@aug.comGlen
otutmaz@aol.comElmhurst

but when something is there before the email i.e. spaces like this
Pi oni@optonline.netPortage
DP pollonais@collegeclub.comPALM
Caprice ct randall.e@aug.comGlen
22 kemville otutmaz@aol.comElmhurst
here it does not work...


pappyjump@aol.com HoustonTX (where single space is already there after "H")
orit.moalem@adttsa.com Petaluma (where single space is already there after "H")

Please correct me if am wrong somewhere.....

[macropod]

Hi xavier,

Try changing the Find expression by adding a '<' after the first '(', that is:
Find = (<[! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])

[kjxavier]

Originally Posted by macropod

Hi kjxavier,

Try a wildcard Find/Replace, where:
Find = ([0-9]{3}-[0-9]{4})([0-9]{2})
replace = \1 \2

Hi!

I have many Email ID's converted from some software.
But for some ID's there are Case Problems

E.g.: RUBLE@MSN.COM this is OK(let the Capital Mail ID's contain Cap Extension)

But : becky@msn.COM this ID should be becky@msn.com
St.navygary3@aol.COM should be St.navygary3@aol.com

how can solve the Extension Case Problem using WildCard

[macropod]

Hi xavier,

You can solve this with a wildcard Find/Replace, where:
Find = (HYPERLINK "mailto:[!\@]{1,}\@[a-z]{1,}.)(COM)
Replace = \1com
and, before executing the Find/Replace you toggle the field code display 'on' via Alt-F9. Toggle it 'off' via Alt-F9 again afterwards.