Thread: [Solved] Find and Replace
View Single Post
 
Old 08-10-2011, 10:07 PM
kjxavier kjxavier is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Find and Replace...

Quote:
Originally Posted by macropod View Post
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
Reply With Quote