Skip to main content
Solved

Test conditions - how to test string to contain letter combinations?

  • August 18, 2020
  • 4 replies
  • 104 views
lazarlubomir
Contributor
Forum|alt.badge.img+10

Hello everyone,

please, Im thinking about the most simple way, how to test text string to contain any letter combinations?

E.g. I have got some codes - 1B3DDD386MND, 1B3DDD386CDL etc. and I have separately Excel file, where are allowed and forbidden letter combinations. CDL is forbidden string combination, so I need to detect this combination. In Excel, there are thousands of these combinations, so its highly time demanding to put all this combinations to tester transformer with CONTAINS condition.

Any tips how to solve it highly effective?

 

Thanks a lot!

Lubo

Best answer by davtorgh

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • August 18, 2020

I would use an InlineQuerier here, to only keep codes that don't contain a value listed in your excel fileCapture

SELECT C.* FROM "Codes" C, "Excel" E
WHERE C.code not like '%'||E.Forbidden||'%'

 

 

davtorgh
Contributor
Forum|alt.badge.img+12
  • davtorghContributor
  • Contributor
  • Best Answer
  • August 18, 2020

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • danilo_fmeCelebrity
  • Celebrity
  • August 18, 2020

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

I checked your Workspace, good job!

Partner Solutial Brazil - www.solutial.com.br
lazarlubomir
Contributor
Forum|alt.badge.img+10
  • lazarlubomirContributor
  • Author
  • Contributor
  • August 20, 2020

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

Nice one! Thank all for Your tips!

Community Stats

32,208
Posts
122,308
Replies
39,892
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.