Hello, I have a report that shows a column for a type of employee ID. The value is categorized as string even though they are numbers. The rows with 9 characters in the ID column are valid. Some of them have 8 characters and these are not valid so I would like to remove them. I am thinking string manipulator? But am unsure of how to write it.
Hello @eckers85 and welcome to the KNIME forum.
As they are categorized as string, ‘String Manipulation’ node and ‘Row Filter’ afterwards can do the job.
length($columnID$)
BR
2 Likes