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 4 Next »

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

  • No labels