Knime equivalent node to Excel’s left/right functions

Hi,

I intend to extract part of the cell content. In Excel I do this through left/right functions.

So, for the cell with content “Knime Equivalent node”, I want to extract the first 10 characters on the left, what would give me ““Knime Equi”. If on the right, "alent node".

Many thanks in advance,

Cadu

String Manipulation, for left and right:

substr($Col$, 0, 10)
substr($Col$, length($Col$)-10)
2 Likes