Help with rule-based row-filter - according to excel formula

Hello together,

I am really new to KNIME and looking forward to get some help from you. I have the problem, that I have 5 mio rows in CSV and want analyse them. Until now, I alway splitted the data into 1 mio parts. After that I proceed 5 times all the analysis with 1 mio rows, did a PIVOT table and summed the 5 parts together. It took up to 5-6 hours to do that. KNIME was the suggested idea to do it. But I don’t know enough to work with it, unfortunately.

In Excel I used a specific formula to qualify the data and to sort out some rows. Therefore it would be great if you could help me with the right rules.

What kind of rules do I need …

• if cell contains “XYZ”, then it is not included

• if cell contains “ABC” on position 3-6 in the cell, then it is not included

• if cell contains “TEST” , then it is included

Many thanks in advance. Kind regards.