Find and Replace Wildcard character?

Find, replace, find in files, replace in files, regular expressions

Find and Replace Wildcard character?

Postby RTINSC » Thu Nov 17, 2005 8:55 pm

I have large databases and want to find and replace all 6 digit numbers that begin with "2" or "3", etc..

Is this done with 2 followed by 5 wildcard characters?

What is the wildcard character?

Thanks for any assistance.
User avatar
RTINSC
Newbie
 
Posts: 2
Joined: Thu Nov 17, 2005 12:00 am

Re: Find and Replace Wildcard character?

Postby mrainey56 » Thu Nov 17, 2005 10:06 pm

Do a regular expression search, using UltraEdit style regular expressions (read about them in the Help)

search string would be [^0-9] [2-3][0-9][0-9][0-9][0-9][0-9][^0-9]


this translates to "find a non-digit character followed by a 2 or a 3, followed by five digit characters, followed by a non-digit character"
User avatar
mrainey56
Master
Master
 
Posts: 212
Joined: Tue Jul 27, 2004 11:00 pm
Location: Spartanburg, South Carolina

Re: Find and Replace Wildcard character?

Postby RTINSC » Fri Nov 18, 2005 3:15 am

Thanks for the help. It is appreciated. RT
User avatar
RTINSC
Newbie
 
Posts: 2
Joined: Thu Nov 17, 2005 12:00 am


Return to Find/Replace/Regular Expressions