Hitachi Vantara Pentaho Community Wiki
Child pages
  • Replace in String

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0


You could parse out sections of a string as follows

Wiki Markupregex = \ ^(\[0-9\]\{4\})(\[0-9\]\{7\})$

replace with = $2

This will replace any 11 digit numbers with the last 7 digits.


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.