Change characters outside a wildcard while keeping wildcard results

nymusicman · #1 04-09-2014, 10:49 AM

What I want to do:

Find a comma in front of a number ",1" and change it to a period ".1"

How I'm currently doing it

Code:

With Selection.Find
.Text = ",1"
.Replacement.Text = ".1"
...

and repeat for all numbers 0-9.

I'd like to condense this maybe using something like

Code:

.Text = ",[0-9]"

But I'm not sure how to go about it.

Please help!

macropod · #2 04-09-2014, 03:53 PM

Try:

.Text = ,([0-9])
.Replacement.Text = .\1
.MatchWildcards = True

nymusicman · #3 04-10-2014, 08:17 AM

Thank you, that worked. I was just missing paranthesis and the wildcard true statement.

Facepalm moment!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tricky wildcard search	NobodysPerfect	Word	10	03-19-2014 04:29 AM
Wildcard for selective deleting	binar	Word	1	01-10-2013 04:37 AM
Wildcard Problem with Emailadresses	Fmax	Word	1	06-17-2010 06:09 AM
Wildcard search help.	Kempston	Word	0	11-13-2009 03:58 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM