This is probably a stupid question but I can't figure out for the life of me which step would allow the last two character of a string to be deleted in Pentaho Data Integration V9.2

CodePudding user response：

There are many ways to do that, perhaps the simplest is a Replace in strings step, using a Regex (e.g., search for (.*).{2} and replace by $1).

This will replace the entire string by the first capture group, which is made up of the entire string except the last two characters.