Skip to main content
Released

Allow testing against an array of values - new operator "In Array"

Related products:Transformers
  • July 29, 2016
  • 5 replies
  • 54 views

roland
Forum|alt.badge.img+2

it'd be helpful to make testing of text values more easy with a new operator that allows tests against an array/list of values with the functionality of the operator "contains". it'd save a lot of test clauses like shown in the example below

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

david_r
Celebrity
  • July 29, 2016

Have you tried using the "In" operator:

'

It should do what you're asking for.


fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • August 6, 2016

Yes, "In" Should do as desired here. @roland do let us know if it misses the mark.


roland
Forum|alt.badge.img+2
  • Author
  • September 8, 2016

hallo dale, hallo david,

thanks for your feedback, i know the "in" operator, but it doesn't work with text values as i wish! i mentioned obove the new operator should work like the "contains" operator as my left value "strecke" looks like -> a12, s12, b12, c12, a10, s10, b10, c10, t25, s25, b25, c25 .... and i want to filter all text values that contains [12,10,25,96,26]. i hope my question is more clear now, may be i didn't explain it detailed enough.


ebygomm
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • September 9, 2016

 

Agree that this would be useful, or the ability to use a wildcard with the In Operator.

 

In the past I have manipulated the left value before testing with the In Operator for this sort of scenario

 

e.g.

 

'


takashi
Celebrity
  • September 10, 2016

Hi @roland, in this case, the 'Contains Regex' operator might help you. e.g. the following regex filters text values that consist of a non-digit character and [12, 10, 25, 96, or 26].

  • Operator: Contains Regex
  • Right Value: ^[^\\d](12|10|25|96|26)$