Hello. I need to perform a specific string replace, but not sure how to go about it.
The scenario is this: I have a large block of text. Within the text colons appear ":", Sometimes the colons are used in a sentence appearing after a word. Other times they appear in between numbers like a ratio or a sport score (e.g. "6:8").
I want to replace the colons appearing between numeric values like 6:8 with the word "to", but not the ones appearing at the end of a sentence.
Is there a way that I can have StringReplace (or any other method) differentiate when to replace the colon based on it appearing between numbers?
I did try searching for a similar scenario.
Thank you for any help.