Coda doesn’t have a great way to do this at the moment. We can Find() text, but we don’t have an officially supported formula for changing the style of that text. There is a hidden formula that will let us do this, but these might disappear at anytime. So it’s a use at your own risk example here…
Here’s a solution that can match phrases. It’s a multi-step one though. Also it should be a more robust one than the one above, since it doesn’t split the text by every word but only wherever necessary to then stitch it back.
It uses a hidden RegexExtract formula; it supports flags so instead of using Lower() elsewhere I just set it up to work as case-insensitive.
Hey @Paul_Danyliuk, thank you so much for this amazing doc, all this Regex stuff is really black magic for me.
Your version is almost perfect for my use-case, the only thing that doesn’t work as I would expect is that matches are also found even if the keyword in the text has some spaces in between.
For example the keyword ‘Dan’ would produce a match in ‘how I didn’t adD ANything extra’.
Do you think it is possible to adapt the Regex formula to solve this?
I tried with Claude and ChatGPT but didn’t manage to make it work.