![]() |
|
#1
|
||||
|
||||
![]() 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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
it worked at one place ... but for some other lines it didn't.
Find ![]() 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 |
#3
|
|||
|
|||
![]()
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..... |
![]() |
Tags |
find and replace |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
find and replace | anil3b2 | Word | 0 | 08-03-2010 11:30 PM |
help with find and replace | sjkiss | Word | 1 | 04-12-2010 08:08 AM |
find and replace graphics | thegeester | Drawing and Graphics | 0 | 04-04-2010 04:36 AM |
Find /Replace Help | ilcaa | Word | 2 | 11-02-2009 08:41 AM |