sorry I suppose it is already written somewhere but I was not able to find it.
Is there an escape character that I can use to use “bad characters” in formulas.
For example: Replace(“C:\Company” , “C:\”, “https://”)
Hi!
We confirm that as a bug, and will fix that! Thank you so much for the report
As a current workaround you can try: Replace("C:\Company" , 'C:\', "https://")
Using single-quotes in the middle
FYI:
With next release we will add proper support for escaping " in double-quoted strings in formulas (using \"), and for escaping ’ in single-quoted strings (using \').
Note that only those two escape sequences are possible, no support for unicode or hexadecimal sequences, \r \n, etc. If you use Regex function, you pass regular expression via string constant. Same rules for escape sequences are applied there. After processing these 2 escape sequences, your regex string is passed to regex engine and works according to general regex rules.