SUBSTITUTE
Substitute’s new_text for old_text into the given value.
Syntax
SUBSTITUTE(val, old_text, new_text)
Example
If myfield has value 'ABC|DEF', then:
SUBSTITUTE({{myfield}}, '|', '\n') replaces | with new linereturns:
ABCDEF
SUBSTITUTE(val, old_text, new_text)
If myfield has value 'ABC|DEF', then:
SUBSTITUTE({{myfield}}, '|', '\n') replaces | with new linereturns:
ABCDEF