Escape character for bad characters in formulas

Hello,

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://”)

The issue seems to be the backslash.

Thanks a lot.

Best, Alex

1 Like

Hi!
We confirm that as a bug, and will fix that! Thank you so much for the report :slight_smile:
As a current workaround you can try:
Replace("C:\Company" , 'C:\', "https://")
Using single-quotes in the middle
:hugs:

2 Likes

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.