Search code examples
pentaho-spoon

Need to Replace in string with pentaho

I have to replace a part of strings in fields rows. Perhaps if anybody have some knowledge about using the replace in string with pentaho.

string to replace:

string to replace

Solution

  • Use Replace in String step. Type the String you want to search in the Search field and in the Replace with field, you have to type the String that will replace the existing String you searched.

    You can always browse to ../Pentaho/design-tools/data-integration/samples/transformations for the examples.