Hi, I’m a new knime user and I’m kind of stuck.
I need only the data that are exact 9characters long and have the following format
I tried to use string manupilation but then I get everything that have max 9 characters.
Hoping someone can help me
Welcome to the KNIME Forum!
Do you mean you want to keep only the rows that have data in this format in a specific column? In that case you can use the Row Filter node. It has a “Pattern” field where you can specify a regular expression. That is a special expression that describes how a string should look like. In your case: 3 uppercase letters, a dash, then 4 digits, another dash, then 3 digits can be expressed as:
You can use a tool like the fantastic regex101.com to try out your patterns and learn more about regular expressions.
IT WORKS ! Thank you Alexander for the help and the tip.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.