REPLACE_CHARS takes three strings as arguments. It replaces, character by character, occurrences of each character in the second string with the character at the same place of the third string.


This can be very useful if you need to replace a list of special characters, e.g. if you want to replace all umlaute (e.g.ä with a) with similar ascii characters you could use this rule:

REPLACE_CHARS('I am a string in german: Klimagerätestörung', 'äöü', 'aou')

This will return Klimageratestorung.

Last updated