String Manipulation (Multi-Column) - Conditional Formatting

KNIME Analytics Platform
2

Hi @KaboboJakobo , the String Manipulation (Multi Column) node doesn’t have the and, not, if etc statements that you are trying to use. It does however contain the ability to incorprate the functions listed within the node, along with some java constructs for conditions

Your code to add a full stop (period for those using US English :wink: ) where it isn’t already present, would be:

join($$CURRENTCOLUMN$$,
	$$CURRENTCOLUMN$$!=null && !($$CURRENTCOLUMN$$.endsWith("."))
	?"."
	:""
)

(edited as we can in fact use the java endsWith() method on a String column, which I hadn’t previously considered :wink: )

So:

Your Construct String Manipulation equivalent
isMissing(x) x==null
not(isMissing(x)) x!=null
not(x ) !(x )
and(x,y) x && y
if(x,y,z) x?y:z
endsWith(x,y) x.endsWith(y)

Additional info on String Manipulation’s “undocumented” features

btw, welcome to the KNIME Community! :slight_smile: I can’t possibly comment on Stack Overflow’s “crowd”, but I think you will find that the KNIME Community are (probably) the friendliest data community in the world. :wink:

4 Likes