Skip to main content
Question

Tester - filter values that contain "text. (anynumber)"

  • March 27, 2018
  • 3 replies
  • 240 views

Forum|alt.badge.img

I would like to ask how can I filter data by using Tester consider condition:

ATTRIBUTE_ABC - contains - "max. 1" or

ATTRIBUTE_ABC - contains - "max. 2" or "max. 3" etc.

how can I generalize Tester by substituting number 1, 2 or 3... to don't build x number of testers.

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.

3 replies

oscard
Influencer
Forum|alt.badge.img+22
  • Influencer
  • 344 replies
  • March 27, 2018

I would use the condition:

ATTRIBUTE_ABC -> Begins with -> max.


Forum|alt.badge.img
  • Author
  • 10 replies
  • March 27, 2018

Hi @oscard

 

attribute value looks for instance like this - > abc max. 20A

 

I need to check if person who collected data didn't omit numeric value like "20A" or "40A" etc

That's why I'm thinking to use

ATTRIBUTE_ABC -> CONTAINS -> .....

However, I don't know how to create general condition for "right value" in tester.


takashi
Celebrity
  • 7843 replies
  • March 27, 2018

Hi @vid, the "Contains Regex" operator can be used to test the pattern of string (Left Value). For example, this regex (Right Value) matches a string consisting of literal "abc max. ", one or more number, and literal "A".

^abc max\. \d+A$
  • "abc max. 20A" -> Passed
  • "abc max. 20B" -> Failed
  • "abc min. 20A" -> Failed

and so on