Hello,
I have a list, where after using JOIN() I am able to make it a comma separated string.
I wish to replace all “,” with “|”.
Using REGEXREPLACE() just replaces the first instance of “,”.
recHXRvsR7wlBuWBQ,rec0hpn4JtduIrFNQ,recPCPq6iBXAtBxoi,rec26YwnpUIf5433Y,recg4k44Rw4BUppCZ
becomes
recHXRvsR7wlBuWBQ|rec0hpn4JtduIrFNQ,recPCPq6iBXAtBxoi,rec26YwnpUIf5433Y,recg4k44Rw4BUppCZ
What is the best way to replace multiple characters ?
Is it possible to do it without using Custom Code?
Regards
Yash