Skip to main content
Question

Tester - IN Operator - everything passes if no quotes included and hyphens present


ebygomm
Influencer
Forum|alt.badge.img+39

I'm pretty sure that when using an IN clause in the tester, a comma separated list of values could be used as long as there were no spaces, there was no need for additional quotes.

 

However, it looks like there is an issue with the tester - if i send a list with no quotes, everything passes!

 

 

If the quotes are required due to the presence of the hyphen, then surely the middle option should fail everything rather than pass everything?

FME 2019.1.0.0 (Build 19608 WIN32)

4 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • August 22, 2019

It is mentioned in the documentation for the Tester.

Without the quotation the A-Z means the range from A to Z.

I have to admit this is known to me by experience, not by knowing all documentation.


ebygomm
Influencer
Forum|alt.badge.img+39
  • Author
  • Influencer
  • August 22, 2019
erik_jan wrote:

It is mentioned in the documentation for the Tester.

Without the quotation the A-Z means the range from A to Z.

I have to admit this is known to me by experience, not by knowing all documentation.

Is it in the documentation? I've found previous answers which quote part of the documentation but can't find it in the current.

Either way, I'm not sure how the value ID-X080 is interpreted as being in the range ID to X079?

I'd expect FME to be cleverer than this, and create an error if trying to test with a range such as ID-X079? I note that you can use letters for greater than and less than too....Naturally IDZ070 is less than X079 as is WDZ070784494


erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • August 22, 2019
ebygomm wrote:

Is it in the documentation? I've found previous answers which quote part of the documentation but can't find it in the current.

Either way, I'm not sure how the value ID-X080 is interpreted as being in the range ID to X079?

I'd expect FME to be cleverer than this, and create an error if trying to test with a range such as ID-X079? I note that you can use letters for greater than and less than too....Naturally IDZ070 is less than X079 as is WDZ070784494

You are right. Can't find it in the current version of the Tester documentation. I am sure it used to be in there.


erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • August 22, 2019
ebygomm wrote:

Is it in the documentation? I've found previous answers which quote part of the documentation but can't find it in the current.

Either way, I'm not sure how the value ID-X080 is interpreted as being in the range ID to X079?

I'd expect FME to be cleverer than this, and create an error if trying to test with a range such as ID-X079? I note that you can use letters for greater than and less than too....Naturally IDZ070 is less than X079 as is WDZ070784494

Found this in the Tester Help:


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings