Can I use regex in the filter operations? I have data like this:
I want to filter the rows that end with “.txt” in colum “Date 2” (ignoring case) using regex
Yes you can do that easily just by using the Filter Row on Expression Result operation. By giving it a standard groovy expression in the Expression field e.g.
Data_2 ==~ /(?i).*\.TXT/
You will get the result:
Also please note how the column “Data 2” can be addressed using Data_2. You could actually equally use Data2 instead.