Replace multiple statement using an array


In other languages/tools i can replace characters using correspondance array like :
‘éèê’ replaced by ‘eee’ .

Any smart solution to do something like this ? Nested replace function are so long to write :confused:

Another request, can we have an option in the upper / lower function to ignore accentueted chars ?
so ‘être’ become ‘ETRE’ and not ‘ÊTRE’


1 Like

This is a very good point.

We will be adding a new action named “Replace with lookup” in version 4.7 to be released in a week or two. The action will use a lookup table to replace multiple substrings at once in multiple columns.

1 Like

Juste tested it ! Very nice :slight_smile:

Thx !