Find and Replace Wildcard character?

RTINSC · Nov 18, 2005#12005-11-18T01:55+00:00

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.

mrainey56 · Nov 18, 2005#22005-11-18T03:06+00:00

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"

RTINSC · Nov 18, 2005#32005-11-18T08:15+00:00

Thanks for the help. It is appreciated. RT