Replace in String

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.

You could parse out sections of a string as follows

• regex = ^([0-9]{4})([0-9]{7})$

All fields of this transform support metadata injection. You can use this transform with ETL Metadata Injection to pass metadata to your pipeline at runtime.