Equivalent to excel extracting left or right after a specific Character

[mh_elhassan]

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 “,”

[HansS]

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

[mh_elhassan]

Thanks. i really appreciate it