RegexMatch supports options

#1

Hi there!

There seems no additional option in RegexMatch formula in https://coda.io/formulas, like most regex regines do.
The original request of mine is to perform case-insensitive match in table filtering. I’ve tried ‘/hello world/i’, but it seems not working.

Could you add options to RegexMatch. Or, at least a way to perform case-insensitive regex match?

Best,

Xinyu

#2

Hi - you can do this by converting everything to lower case such as this example discusssed in an earlier thread on this forum:

image
image.png1029×76 15.5 KB

#3

Thanks Richard! That’s neat and solves my problems for now