REPLACE_CHARS

Description

REPLACE_CHARS takes a string and two character sequences of equal length, and replaces each character from the first sequence with the corresponding character from the second sequence.

This is useful for character-by-character substitution, such as swapping accented characters or normalising delimiters.

Example

REPLACE_CHARS('a,b;c', ',;', '||')

This replaces , with | and ; with |, returning "a|b|c".

Last updated

Was this helpful?