Skip to main content
  • EN
Does the IN operator in the TESTER extend to working with string elements as well as numbers?  The FME help documentation shows a number example (below) but I would like to search a string element list:

 

 

Help example:

 

X=5, is X In 1,2,3 (no = FAIL)

 

 

Why can't I do this:

 

X=hello, is X In hello,goodbye (yes = PASS)

 

 

I am running FME2012 (SP0) if that is the limiting factor?

 

I have tried quoting the string elements?

 

I have tried a regex operator using the (hello|goodbye) syntax?

 

 

I have an attribute that I want to filter on 10 or so qualifying values - I could build a lengthy OR statement in TESTER but I was hoping for a simpler workaround.
Hmm ... looks like one workaround is to use the StringSeracher with a regex that looks like this:

 

 

^(hello|goodbye)$

 

 

Still doesn't explain why "IN" in the TESTER does not work for me or why the same regex notation does not work with the TESTER?

 

 

Haven't had a chance to test this with a later FME build.

 

 

Mike
Hi Mike,

 

 

I use FME 2013 SP4 and the IN operator works well with your examples.

 

 

Thomas

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.