[dba-Tech] Word Replace with wildcard

[Susan Harkins]

Got it!!!!

Find: <3([0-9])([0-9])>
Replace: 5\1\2

Thanks!
Susan H. 

-----Original Message-----
From: Susan Harkins <ssharkins at gmail.com> 
Sent: Thursday, April 1, 2021 9:58 AM
To: 'Discussion of Hardware and Software issues'
<dba-tech at databaseadvisors.com>
Subject: RE: [dba-Tech] Word Replace with wildcard

I've got it close, but I can't limit it to 3-digit numbers. 

Find: (<3)(?)(?)
Replace: 5\2\3

It works with 302, 398, 357, and so on, but it also changes 3598. 



-----Original Message-----
From: Susan Harkins <ssharkins at gmail.com> 
Sent: Thursday, April 1, 2021 9:36 AM
To: 'Discussion of Hardware and Software issues'
<dba-tech at databaseadvisors.com>
Subject: 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.
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com