Solved: How do i use contain expression trying to find cer... - Page 2

Tiger1 · 01-15-2020 08:57 AM

I am using the contain expression to find zip codes. I cannot figure out how to add mutiple zip codes to search:

Current expression:
contains([last seen location] ,"77905""77976""77404""77905""77976""77404""77414""77483""77419""78075""78022""78071"“78385”
"78140""78159""77963""77993""77954""77967""77974""77989""77994""78141""78164""77975""77964""77984""77995"“77987”)

Joshua_Aldrich

I don’t think that will work mainly because contains is expecting text not a list. A nasty workaround would be:

OR(Contains([Last seen location], “77905”), Contains([Last seen location], “77976”),… )

This will check the string for each of the keywords. The OR expression will evaluate to true if any one of them are true.

View solution in original post

How do i use contain expression trying to find certain zip codes