CreativePro Forum

Return to Member Forum

• Author
  Posts
• • July 31, 2018 at 8:29 am #105134
    Sharon Garcia

    Participant

    I am trying to you some Index Scripts for a publication that has 974 different Biblical cites. Obviously we would rather not do these manually. First of all I need a Find/Change formula to find digit:digit. I have tried some that I found on the forum but they do not work. Example John 3:16. If I can find any digit, then a colon, then any digit, I can find the references. Could someone help me, please. Thanks, Sharon

  • July 31, 2018 at 8:58 am #105135
    Aaron Troia

    Participant

    Sharon,

    Here’s one that I put together or found awhile back and have modified to find most instances of book and verses. I’m not sure if its exactly what you’re looking for for indexing but thought it might help.

    (\(| )\K([1-3])?(~s|~S| )?([a-zA-Z]\w+|[a-zA-Z]+)\.?(?<!and)(\d+)(?:\:(\d+))+((?:, |\–|\-)(\d+|[A-Z]+?))?(?= |\)|\;|\.)

  • July 31, 2018 at 9:07 am #105136
    Sharon Garcia

    Participant

    No, Aaron, unfortunately not. Looks like a lot of brain power poured into one formula. I think we will be fine if we can find a simple formula for digit-colon-digit. Thanks so much

  • July 31, 2018 at 9:26 am #105138
    Aaron Troia

    Participant

    oh ok, sorry, yeah it is a beast of a regex. Here is a simple digit:digit regex

    \d+:\d+

  • July 31, 2018 at 1:36 pm #105145
    Sharon Garcia

    Participant

    Great help. Worked like a charm!

• Author
  Posts