Use Rule Based Row Filter with char " * "

[BCadete]

Dear forum,

As a new KNIME user, I was wanting to use the Rule Based Row Filter to exclude rows in my dataset that start with the characters **.

As the character * is also used to identify a wildcard I wasn’t able to actively use it for filtering.

Does anyone know how to best tackle this?

Example rows that I wish to exclude:

** AMASIS = 12345 ****************************

---

***********REPORTS X ************************

Thanks for any insights.

Cheers

[Andrew_Steel]

Hi @BCadete,

$column1$ MATCHES "[*]{2,}.*" => FALSE
matches all rows which starts with 2 asterix

Best Regards
Andrew

[BCadete]

HI Andrew,

Perfect solution.

Thanks for the quick feedback.

Best Regards,
Bruno