View Single Post
 
Old 02-05-2021, 08:33 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,371
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by VBAFiddler View Post
I'd still be interested to know a bit more about setting up a regular expression for my original criteria.
For example:
Find = <[0-9A-Z]{1,2}[a-z.]{2,5} [0-9]{1,}:[!^s .,;”\)]{1,}
Note: the 5 in {2,5} assumes longer names are abbreviated.
Quote:
Originally Posted by VBAFiddler View Post
Looking at your code, I can see a couple of or (|) in there, and I assume that it can be used to specify an alternative which isn't always true, but could be
No. In StrBks, for example, they're used to delineate where | characters in the string are to be replaced by non-breaking spaces, which the board software doesn't support. This is explained in the preamble. In the calls to MakeDupes & HideDupes, they're used to delineate where | characters in the string are to be replaced by either a comma or semi-colon, depending on the user's regional settings.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote