Filter & Comma Deliminated Question

[dbdirks]

I'm trying to find a simpler formula to use in a filter.  For example, I've got a file containing every state across the US, If I want to filter specific states instead of writing out [State] = "CO or [State] = 'TX', etc.. for each state individually, can I do something like [State} within (DE,IL,KS,MA,MD,ME,MI,MN,NH,NJ,NY,OH,PA,RI,UT,VA,VT,WI)? Basically I don't want to have to write out each state individually.

[mceleavey]

@dbdirks ,

It sounds like there's a much easier way of doing this. 

Can you post some mock data so we can see the format and what you're trying to do?

M.

[CarliE · Accepted solution]

Hi @dbdirks,

You can do [State] in ("DE","IL","KS","........) --  Each value needs to be wrapped in quotes since its a string.

If this solved your problem, please mark as a solution to help other members on the community.

Thanks,

[dbdirks]

Thanks Carli! I knew I was close but forgot about the quotes. This worked.

[PangHC]

i know it solved, but when come to this amount of criteria. (>10)

it better to put in an excel/ text tool, then join tool to filter. it easier to check and change in future.