TRANSFORMER
REPLACE
REPLACE is a calculator function that replaces a substring in a string.
Choose a field that is to contain the result in the Result Field drop-down list at the top, or create one by entering a new name.
Syntax
REPLACE(<fieldName>,<toBeReplaced>,<newValue>)
where <fieldName> is the name of the field containing the string, <toBeReplaced> is the substing (value) that is to be replaced, and <newValue> is the value that is to be inserted.
The values in <toBeReplaced> and <newValue> must be enclosed in double quotation marks " ". When <fieldName> is text it must be enclosed in double quotation marks.
Examples
REPLACE(${Description},"E"," ")
In this example, the letter "E" will be replaced with a space in the field called Description.
REPLACE("Description","e"," ")
In this example, the letter "e" will be replace by a space in the word Description.
