Findstring for 2 or more values

[Mancunian]

I have a coloumn with all months and years since 2011, but I just need to extract the years 2016 and 2017. How can I specify these 2 years in a single FindString Formula.

The data is  april, 2016, May, 2013, January 2017

I have been trying this but to no avail.

FindString([DateTime_Out],"2016"&"2017")>-1

[Kenda]

Hey @Mancunian! I would add the following expression to a Filter tool instead of using the FindString. Does this still accomplish what you're wanting?

right([Field1],4)="2016" || right([Field1],4)="2017"

[MarqueeCrew · Accepted solution]

Hi @Mancunian,

Please try one of these formulas (whichever tickles your fancy):

regex_match([Field1],".*2016.*|.*2017*")

Contains([Field1],"2016")
OR
Contains([Field1],"2017")

You could even use Findstring if you use the OR construct.

Cheers,

Mark

[jdunkerley79]

An alternative to @Kenda

right([Field1],4) IN ("2016", "2017")