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