What is your goal?
I want to replace multiple commas in a string using the replace() function.
What is the problem & what have you tried?
The replace() function in itself works perfectly fine! However, Make’s UI is completely messed up which lead me to working on one formula (with a lot of nested functions) for hours! Let me explain, by looking only at the replace() function:
{{replace(xyz; ","; "")}}
When copying my code, everything looks fine, since the syntax is correct. However, when I use the Make UI to create the formula, I have to leave out the quotations marks (“”) around the comma or otherwise the function won’t work (see screenshot 1).
Ok, fair. Now you’d think, that this means that Make automatically encapsulates all arguments of the replace() function into quotation marks. Therefore, if you want to get rid of the comma in your string, you simply leave the last argument empty.
WRONG! You actually have to type in the quotation marks into the last argument of the Make UI or the formula won’t work as it creates something like this {{replace("xyz"; ","; )}}! So, basically it leaves out the quotation marks in the last argument and therefore you have to add them there.
What bugs me most about this is, that Make AUTOMATICALLY removed the empty quotation marks for me (that I manually added!), when if I later on put the replace() function into a different function and then saved the module. So basically, once you get the replace function to work with this weird behaviour, you can start debugging your nested formulas only to figure out that Make deleted the quotation marks and that this was the issue - not your wrong formula logic, but Make somehow doing what it wants.
Can we please get this fixed?
