Equivalent to excel extracting left or right after a specific Character

Hello Community,
i hope this finds you well
I need your help in finding knime equivalent to the following function in excel

LEFT(A1, FIND(“,”, A1)-1)
extracting all texts from col A1 left of the “,”

Hi @mh_elhassan

Multiple Ways to do this in KNIME. One way to go is using the Cell Splitter node. Where the delimeter is “,” and you set the array size to 2.

Or go for the String Manipulation node:

substr($column1$,0 , indexOf($column1$, "," ) ) 

gr. Hans


Thanks. i really appreciate it

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.