Hitachi Vantara Pentaho Community Wiki
Child pages
  • Replace in String

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


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.For example


you You could parse out sections of a string as follows


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.