Thread: [Solved] Find and Replace
View Single Post
 
Old 07-24-2011, 09:16 AM
kjxavier kjxavier is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Thumbs up Find and Replace

Hi!

The Second Widcard worked perfect.

But the First one for E-mail ID has some prob i quess ! At a place it worked but not on all fields of mail id. All i need is DOUBLE SPACES before and after email.

is there anything wrong with the way i did.

Anyways can you help me with the attached file please and a WILDCARD for the same

Regards and Thanks you for the same
Xavier


Quote:
Originally Posted by macropod View Post
hi xavier,

For an email address preceded by one or more spaces, try a wildcard Find/Replace where:
Find = "[ ]{1,}([! \@]{1,}\@*.[! ]{1,})[ ]{1,}"
Replace = " \1 "

For the alpha-numeric strings, try a wildcard Find/Replace where:
Find = "<[A-Z]{2}[0-9]{6}>"
Replace = "^&"
and set the colour format the replacement as red.
Attached Files
File Type: doc xavier.doc (144.3 KB, 11 views)
Reply With Quote