I need to delete the last 2 digits of all cells in a column, which nod do I use?

I need to delete the last 2 digits of all cells in a column, which nod do I use?

Hi @Gabbrasilino , welcome to the KNIME forum.

There are a few ways, but two possibilities could be the String Replacer or String Manipulation nodes.

Do you have a few examples of your data though.

Is your data actually numeric (e.g. integer) (in which case dividing by 100 in Math Formula and rounding the result could be a solution!)

Or is it character data, and if so, are the last 2 digits to be found anywhere in the string (and are the two digits always together?), or will they always be the last two characters of the string?

Sorry to have so many questions from such an apparently straightforward question, but it is open to interpretation, and it could make a big difference over which way to do it.

btw I have moved your question to the general KNIME Analytics Platform part of the forum, as the “feedback and suggestions” area won’t always get the same amount of coverage from other users.

1 Like