±replace

Replaces parts of a CSV table field with a replacement expression

Description

Partially replaces certain sections of a data field with replacement content.
The old and the new content are separated by a slash separator ("/").
The replacement pairs are then separated by commas.
Do not forget to escape all brackets with prepending a backslash, see also Placeholders .

The current as well as the replacement content can be a literal string, some field content, or a more complex expression.
The expressions of both sides are resolved before replacement takes place.

When you do several replacements in one ±replace command, they will be done simultaneously. There is no sequence of provcessing. If you want to replace "Cat" by "Dog" and "Dog" by "Cat", both replacements will happen independently and there will be no interference between them.
Therefore, if some special effect is aimed in doing replacements in a certain order, several ±replace commands must be used one after the other.

You can also replace more than one content part with a common replacement. To achieve this, all parts to replace, as well as the replacement, are concaternated with a slash, the last part of this combination is then interpreted as the replacement.

Pattern

±replace[Field]=OldContent/NewContent,OldContent/NewContent,... ±replace[Field]=OldContent/OldContent/OltContent/NewContent,...age examples

bla