in

check if a value is in a set of values

test.csv
1name,count
2rust-1,1
3rust-2,2
4python-1,3
5python-2,4
6go-1,5
7go-2,6
1filterx csv -H --oH test.csv "name in ('rust-1', 'python-1')"
2
3## Output
4# name,count
5# rust-1,1
6# python-1,3

check if a substring is in a Column

1filterx csv -H --oH test.csv "'rust' in name"
2
3## Output
4# name,count
5# rust-1,1
6# rust-2,2

not in

same as in but opposite

ON THIS PAGE