Replace in String
Replace in String
Description
Replace in string is a simple search and replace. It also supports regular expressions and group references. group references are picked up in the replace by string as $n where n is the number of the group.
Example
You could parse out sections of a string as follows
regex = ^([0-9]{4})([0-9]{7})$
replace with = $2
This will replace any 11 digit numbers with the last 7 digits.
Metadata Injection Support (7.x and later)
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.
, multiple selections available,
Related content
String operations
String operations
More like this
Regex Evaluation
Regex Evaluation
Read with this
Strings cut
Strings cut
More like this
Insert - Update
Insert - Update
Read with this
Copy rows to result
Copy rows to result
Read with this
User Defined Java Expression
User Defined Java Expression
More like this