[dba-Tech] Word Replace with wildcard

Susan Harkins ssharkins at gmail.com
Thu Apr 1 12:46:37 CDT 2021


Got it!!!!

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

-----Original Message-----
From: dba-Tech <dba-tech-bounces+ssharkins=gmail.com at databaseadvisors.com>
On Behalf Of Rocky Smolin
Sent: Thursday, April 1, 2021 12:14 PM
To: Discussion of Hardware and Software issues
<dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] Word Replace with wildcard

Haven't seen the post with the solution yet.  Sent?

r

On Thu, Apr 1, 2021 at 8:55 AM Susan Harkins <ssharkins at gmail.com> wrote:

> < > denote the beginning and ending of a string, respectively -- so 
> you don't need the spaces -- but I've figured it out. If you haven't 
> seen that post, you should soon.
>
> Susan H.
>
> -----Original Message-----
> From: dba-Tech 
> <dba-tech-bounces+ssharkins=gmail.com at databaseadvisors.com>
> On Behalf Of Rocky Smolin
> Sent: Thursday, April 1, 2021 11:48 AM
> To: Discussion of Hardware and Software issues 
> <dba-tech at databaseadvisors.com>
> Subject: Re: [dba-Tech] Word Replace with wildcard
>
> Yeah, really worked well in DOS for file searches.  But that was in 
> the previous century, wasn't it?
>
> OK- brute force alternative - assuming the doc is not a thousand pages 
> and there are a relatively small number of these replacements - search 
> for 3 with a preceding space - (space)3 - and replace with (space)5, 
> but not global, so you stop at each occurrence of a string that has a 
> preceding space and starts with three. Then click Replace or Find 
> Next.  Then if it stops at a string of four digits - 3123 - you could 
> bypass the replace. How long would that take?
>
> r
>
> On Thu, Apr 1, 2021 at 8:37 AM Susan Harkins <ssharkins at gmail.com> wrote:
>
> > No, that replaces 3xx with 5?? -- interprets ? as a literal 
> > character, not a wildcard.
> >
> > I saw a lot of examples online using ? but it never worked for me.
> >
> > Susan H.
> >
> >
> > Does the ? serve as a wildcard? Would replace 3?? with 5?? work?
> >
> > r
> >
> > On Thu, Apr 1, 2021 at 6:16 AM Susan Harkins <ssharkins at gmail.com>
> wrote:
> >
> > > 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
> > >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list