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,').
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.
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.
+17- 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
+12- 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
+64- 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
+64- Evangelist
You're welcome, I'm glad I could help you.
Regex does take some getting used to.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.