Replaces part of a string in a field with another string.
Specify here “Field”, “Replace with string” and “If multiple hits”.
For example, if you specify “Grams” for “Replace With” and “g” for “Replace With”, 3.5 grams will be replaced by “3.5g”.
Select the field you want to replace. Multiple selections are allowed, and all selected fields are replaced at the same time.
The available field types are:
Enter the string you want to replace.
Enter the replacement string. If this parameter is empty, it means that the replace will remove the “replace string”.
Select the behavior when there are multiple occurrences in the “From” field value: “Replace All” or “Replace First One”.
Select “Replace All” to replace all occurrences of “Replace With”. If you select “Replace the first one”, only the first one found (the previous one as a sentence) will be replaced.
You cannot use a regular expression for Replace With.