Hitachi Vantara Pentaho Community Wiki
Child pages
  • Replace in String

Versions Compared

Key

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