FME Desktop 2020.0.0.0: How to filter based on exact two values?
For example, in the screenshot below, I wanted to filter all the values that exactly have the number “10” Or “11”.
Then why the “101”, “102”, “110” are filtered with the syntax above?
Solved
FME Desktop 2020.0.0.0: How to filter based on exact two values?
+5Best answer by geomancer
Use regex
,10$Adding $ makes the regex look for values ending with ',10'
Maybe add a second condition (OR) for
^10,(attribute starts with '10,').
+10- Safer
Hi Jamal,
If you are wanting the Tester to find specific values, I'd recommend using the operator "=" (Equal) instead of "Contains Regex".
-Andrea
+10- Safer
Hi @jamal
Based on the screenshot, it appears that you have to adjust the tester to do the following
Adjust the Test Statement to "=" instead of "Contains Regex"
See attached workspace and screenshot 
UpdateWorkbench (see attached)
+5Thank you for the help.
To make mor specific, in the screenshot below, I need to filter those which contains EXACTLY “,10”. This means that “,103” or “,107” shall not be filtered.
How this can be performed?
The data and workbench are attached
+47- Evangelist
- Best Answer
Use regex
,10$Adding $ makes the regex look for values ending with ',10'
Maybe add a second condition (OR) for
^10,(attribute starts with '10,').
+5Thank you very much for the help. It works fine
+47- Evangelist
You're welcome, I'm glad I could help you.
Regex does take some getting used to.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.