Remove Rows based on Character Count

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.




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