RegexMatch supports options

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

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

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

Would also like the regex options that are documented on the mozilla developers page. For example, the g flag would be nice to do multi-line search.

Trying to do this right now, MultilineString.RegexReplace('/,.*/g', '') but it doesn’t seem to work.

2 Likes

Now that we have RegexExtract which has an optional parameter for flags I believe the other two regex formulas should be updated to match, I’ve compared them here:

1 Like