Skip to main content
Released

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

siennaatsafe
ebygomm
roland
  • siennaatsafe
    siennaatsafe
  • ebygomm
    ebygomm
  • roland
    roland

roland

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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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+18
  • 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
Influencer
Forum|alt.badge.img+33
  • Influencer
  • 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
Influencer
  • 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)$

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