Google Spreadsheets Regex Case Insensitive (Regexreplace)
I found this:
=REGEXREPLACE("Test","(?i)t","")
It returns what you want
es
google/re2
AFAIK, the only way to enable case-insensitive matching is JavaScript API in google docs.
Apparently, RE2 syntax does support the inline (?i)
case-insensitive modifier:
=REGEXREPLACE("Test", "(?i)t", "")
An alternative that will work is using a Character class, adding both cases of the letter T
..
=REGEXREPLACE("Test", "[Tt]", "")
As Alexander Ivanov wrote,
Yes, I'm understand that this topic has resolved. But I found something fancy!
=REGEXREPLACE("Test","(?i)t","") It returns what you want
es
P.S.: Please, if somebody knows why it works then comment.
Google uses their own re2 regular expressions engine. Using (?i) is allowing you to set the flags for case insensitive search https://re2.googlecode.com/hg/doc/syntax.html