Hitachi Vantara Pentaho Community Wiki
Child pages
  • Replace in String
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »


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.


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.

  • No labels