[dba-Tech] Word Replace with wildcard

Gustav Brock gustav at cactus.dk
Thu Apr 1 08:40:28 CDT 2021


Hi Susan

Oh, that you didn't mention.

Then, I guess, you are left with a VBA solution.

/gustav

________________________________
Fra: dba-Tech <dba-tech-bounces+gustav=cactus.dk at databaseadvisors.com> på vegne af Susan Harkins <ssharkins at gmail.com>
Sendt: 1. april 2021 15:36
Til: 'Discussion of Hardware and Software issues' <dba-tech at databaseadvisors.com>
Emne: Re: [dba-Tech] Word Replace with wildcard

Yes, that's close, but it doesn't stop at only 3-digit numbers. It will
change the 3 to 5 for any number that begins with 5. But it's a good
solution if there's only 3-digit numbers.

Susan H.

-----Original Message-----
From: dba-Tech <dba-tech-bounces+ssharkins=gmail.com at databaseadvisors.com>
On Behalf Of Gustav Brock via dba-Tech
Sent: Thursday, April 1, 2021 9:32 AM
To: Discussion of Hardware and Software issues
<dba-tech at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [dba-Tech] Word Replace with wildcard

Hi Susan

In the Replace window, mark: Search for prefix Search for: 3 Replace with: 5

/gustav

________________________________
Fra: dba-Tech <dba-tech-bounces+gustav=cactus.dk at databaseadvisors.com> på
vegne af Susan Harkins <ssharkins at gmail.com>
Sendt: 1. april 2021 15:15
Til: 'Discussion of Hardware and Software issues'
<dba-tech at databaseadvisors.com>
Emne: [dba-Tech] Word Replace with wildcard

I've run into an interesting find/replace question and I can do it with two
searches, but I believe it can be done in one. I should know this, but for
the life of me, I can't get it right. Hoping for a bit of help.



Problem: Reader has a Word document with several three-digit numbers
beginning with 3. He wants to change the 3 to 5, leaving the other two
digits as is.



Thanks!

Susan H.


More information about the dba-Tech mailing list