Filter

[RAJAYKUMAR001]

Hi Guys,

I have been trying to filter using a filter tool. but facing the phrase error.

My desired output is if the Column has = 1002, 1003,1005 I need the entire to come out in true other in false is that possible ?

Input

1000

1002

1003

1004

1005

1006

Out put required in 2 different files. one that is equal to 1002, 1003,1005  another that is not equal to.

[echuong1 · Accepted solution]

The filter is different depending on if you are using a string or a number. 

If a string, try using the following in the filter under the custom option:

Column in ('1002','1003','1005')

If a number, use the following:

Column = 1002 or Column = 1003 or Column = 1005

See attached for an example.