Filtering out multiple "string" from [field]

I'm trying to filter out multiple string values from a field and tried this but it's not working:-

Contains("Total",[Country]) or
Contains("Total EU3",[Country]) or
Contains("Total(EU + EFTA)",[Country]) or
Contains("Total(EU15 + EFTA)",[Country])

I would need to strip out all the text and not sure if there is a AND OR function?

....also note that if I try this below then I get "malformed Function Call" :-

Contains(,[Country],"Total") or
Contains([Country],"Total EU3") or
Contains([Country],"Total(EU + EFTA)") or
Contains([Country],"Total(EU15 + EFTA)")

Please help?

Many thanks

Evie

Preparation

Accepted answers

jdunkerley79

Think Adam is right

Attached a trick to show how could simplify using sheet names and filters to make it one path through.

WorkFlow_DataClean_SecondFile_v3.yxmd

Evie

Thank you for your help, yes I got it working

Evie

All comments

MarqueeCrew

@Evie

Contains([Country],"Total")

That should find any of the matches that are in your request.

Cheers,

Mark

jdunkerley79

You have an extra comma in the second example:

Contains([Country],"Total") or
Contains([Country],"Total EU3") or
Contains([Country],"Total(EU + EFTA)") or
Contains([Country],"Total(EU15 + EFTA)")

If you are removing all Totals then I would use StartsWith:

StartsWith([Country], 'Total')

Evie

Thank Mark,

I did try that initially within the "Basic Filter", but for some years it would not populate, hence my thinking was that I needed a muti-string formula. I've now amended the file with your command within the "function" section, and its working for all years except 2006 - even after I have created a new excel output file. Hence, my thinking is that its not a function issue, but perhaps a bug in the way it processes the data.

I've attached the files, can you please take a look. I'm really curious to why its happening?

( just a note I could not do a dynamic batch sheet import due to the data having different headers and needing to be transposed for each year)

Many thanks

Evie

170216_PC_90-16_by_country_Enlarged_Europe_v2.xlsx

Cleaned_Data_Country_Enlarged_Europe_v3.xlsx

WorkFlow_DataClean_SecondFile_v2.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703