REPLACE() in a non-case-sensitive way?

[Claje]

Hi,

This question is probably rather basic, but I didn't actually realize until today that the behavior of the REPLACE() function is case sensitive.

What's the best way today to use a non-case-sensitive REPLACE() function?  Would REGEX_REPLACE() accomplish what I need?

[MarqueeCrew · Accepted solution]

yes.  regex_replace([field],"WoRd", 'Replacement') will work because the default is case insensitive.

[Claje]

I will begin updating all of my formulas ;)

Thank you very much for the quick reply!