How to stop Make UI mangling formulas? It automatically removes "" and messes with formula

[Rapid-IT]

I consistently run into issues with the Make.com UI messing up formulas. One aspect of this is that upon saving (or even pasting in a formula) it automatically removes quote marks which one would normally put into a string formula to demarcate values, etc.

For example, this code:

{{if(substring(58.phone_clean; 1; 1) = "0"; "+64" + substring(58.phone_clean; 2); 58.phone_clean)}}

Gets converted into this:

{{if(substring(58.phone_clean; 1; 1) = ""; 64substring(58.phone_clean; 2); 58.phone_clean)}}

There are many examples with things like this occur. It’s driving me nuts, and making it seemingly impossible to use formulas.

What am I overlooking and doing wrong?

[samliew]

I’d do something like this; Use the replace function instead.

{{ replace(replace(58.phone_clean; "/^0/"; "X64"); "X"; "+") }}

^{(copy-paste the above into the field, or type it exactly as shown)}

Hope this helps! Let me know if there are any further questions or issues.

— @samliew