Knime equivalent node to Excel’s left/right functions

KNIME Analytics Platform
1

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

2

String Manipulation, for left and right:

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