!Contain (doesn't contain)

[Neeta_Latwal]

Hi All,

We have one column where more than 200 type of currency are populated but I want the data excluidng 6-7 currency what function can use, please help.

I was using !contains("USD" + "INR" + "GBP" + "abd" + "DEF") but this function is not woking.

Thanks,

Neeta

[SangeetaDoni]

You have use filter tool with "doesn't contain" and syntax  instead of  !contains("USD" + "INR" + "GBP" + "abd" + "DEF")  could be !Contains([column name],"USD") and !Contains([column name],"INR") and !Contains([column name],"GBP") and !Contains([column name],"GBP") 

[kapilrautela_1990 · Accepted solution]

Use Filter tool :
Expression :  [Input_field_name] NOT IN ('USD' , 'INR' , 'GBP' , 'abd' , 'DEF')

[Neeta_Latwal]

Thankyou Sangeeta & Kapil for your quick response

Its really helpful.

[shashanksaie28]

Additionally to the above you can also use 'Select Records' tool if these currency codes always appear at a particular record number. You can mention their respective record numbers (row numbers) in the Configuration options of the Select Records Tool to exclude them.