topic Findstring for 2 or more values in Alteryx Designer Desktop Discussions

Findstring for 2 or more values

Mancunian — Thu, 24 May 2018 04:24:40 GMT

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

Re: Findstring for 2 or more values

Kenda — Thu, 02 Nov 2017 11:41:01 GMT

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"

Re: Findstring for 2 or more values

MarqueeCrew — Thu, 02 Nov 2017 11:41:05 GMT

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

Re: Findstring for 2 or more values

jdunkerley79 — Thu, 02 Nov 2017 12:17:08 GMT

An alternative to @Kenda

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