I would like to replace the whole phrase in a field. I am working in pentaho. Is there a way to do that? first i do a look up of key words and then replace the whole string with a new one.

And want to replace all the field with the "Replace with" only. In this case it must say DVR only.

Thanks in advance!

CodePudding user response：

You can do with like this:

• use RegEx: Y;
• Search: .*(DVR).*
• Replace with: $1