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.

length($columnID$)

BR

2 Likes