View Single Post
 
Old 02-10-2021, 05:57 AM
VBAFiddler VBAFiddler is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2021
Posts: 14
VBAFiddler is on a distinguished road
Question Using the dreaded colon in marking a field

Hi,
Thanks to these forums, I've successfully marked all my bible references preparatory to indexing. However, my index has gone a bit haywire. It's best explained by looking at the field associated with a bible reference.
Code:
"MATTHEW:7:28;01007028028
What the customer wanted was: a heading for each book in the index. No problem, we've MATTHEW followed by a colon. Then he wanted the reference, i.e. 7:28. The problem is that it is being interpretted as a second heading, so I get a heading for each book, and a heading for each chapter. The part after the semicolon defines my sort sequence.
Is there some way similar to the way backslashes are dealt with so that the colon is actually written as a colon rather than being interpretted as a subheading in the index. If not, I guess I'll need to convert the colon in the reference to a period.
Many thanks for any thoughts,
David.
Reply With Quote