String Manipulation, multiple expressions

KNIME Analytics Platform
2

Welcome to the forum, @Gilbert13.

For this, I would use the Column Expressions node. The following expression works if the column name is ColA :

if (or(substr(column("ColA"),7,1) == "B"), (substr(column("ColA"),7,1) == "D") )
    {
        substr(column("ColA"),2,7)
    }

else 
    {
    substr(column("ColA"),2,5)
    }

It’s basically the same as the Excel formula you have now, but KNIMEified:

  • use the substr function instead of MID
  • account for the fact that character indices start at 0 in KNIME
  • adjust format for the column expression node
2 Likes