'Select' ,'Exclude' in multiple fields

[#1]

Dear All,

I want to exclude multiple values from multiple filelds. But it should  done by a single button.

For example,

If i have 3 filelds Named as A,B,C

a)Field A contains: 1,2,3,4,5

   I need to exclude "5"

b)Field B contains: A,B,C,D,E

   I need to exclude "C"

C)Field C contains: John, Brito, Thomas, Sam, Antony

   I need to exclude "Sam"

The final table should be like

(Fields)   A      B       C  

              1      A     John

              2      B     Brito

Can any one help me please.

Thanks,

Pradeep

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

Thanks Gysbert!

It work's, if i want to exclude multiple values in a field. Can i use 1|,2|3|

[Gysbert_Wassenaar]

Yes, change the search string to: (1|2|3)

[#5]

Very Thanks for your reply!

It's working exactly.