Replace multiple occurrence of a character in a STRING

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

Used SUBSTITUTE(), it worked.

DronaHQ Docs have found a new place!

We have updated and moved our documentation to docs.dronahq.com.
You can continue to ask questions in the community here.