Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-05-2021, 10:47 AM
VBAFiddler VBAFiddler is offline Regular expression confusion! Windows 10 Regular expression confusion! Office 2016
Novice
Regular expression confusion!
 
Join Date: Feb 2021
Posts: 14
VBAFiddler is on a distinguished road
Post Regular expression confusion!

Hi,


My brain is about to overheat, as I've been trying to get a regular expression to do the following job.
I've been sent a document consisting of a biblical treatise. The author has asked me to mark all biblical references for indexing. They are in the following format where 9 equals numeric and X equals alphanumeric:
Xx. 99:99
9Xx. 99:99
Xx. 99:99-99
Using the find command, I can get the chapter and verse working, i.e.
[0-9]{1,2}:[0-9]{1,2}
But including the book, i.e.
[A-z][0-9]{1,3}. [0-9]{1,2}:[0-9]{1,2}
produces no results. To throw another spanner in the works, adding a -99 is optional, i.e. most don't but some do.
If anyone can come up with a way to include them all, I'd be extremely grateful. It may be that I end up having to find the chapter and vers, then extend the selection somehow,
Thanks,
Reply With Quote
 

Tags
bible reference, regular expression, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to use wild cards or regular expression in autocorrect kcvinu Word 2 12-14-2018 02:06 PM
Regular expression confusion! Regular Expression Syntax to Search for Alternative Words qubie Word 2 11-29-2017 05:48 AM
VBA code to enable Regular Expression ronmayerle Word VBA 2 11-20-2014 01:09 PM
Microsoft Expression Web ts6947 Misc 0 02-22-2013 08:20 AM
Regular expression confusion! Can pass .expression as a parameter? tinfanide PowerPoint 4 12-28-2012 06:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft