Need to Replace in string with pentaho

Question

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

If you still need help with this, please be more clear. What's your input field? What you want to replace? — jfneis, Dec 06 '16 at 17:16

score 0 · Accepted Answer · answered Nov 29 '16 at 16:29

0

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.

answered Nov 29 '16 at 16:29

Nikhil

621
1
13
25

Thank you for the solution suggested i appritiated – neofito Dec 20 '16 at 14:12
You're welcome. You can accept my answer if it has helped you. :) – Nikhil Dec 20 '16 at 16:03

score 0 · Answer 2 · answered Jan 12 '17 at 15:42

An alternative to "Replace in string":

If you want to replace a part of a String, something you could do is use the "Strings cut" step to cut a part of a string which you want to replace, replace the value by whatever you want and then "Concat fields" to put strings together again.

Need to Replace in string with pentaho

2 Answers2