Findstring for 2 or more values

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

Help

Accepted answers

MarqueeCrew

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

All comments

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

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")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703