Skip to main content
Solved

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

lazarlubomir
Contributor
Forum|alt.badge.img+7

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!

View original
Did this help you find an answer to your question?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • 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+11
  • davtorghContributor
  • Contributor
  • Best Answer
  • August 18, 2020

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • August 18, 2020
davtorgh wrote:

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

I checked your Workspace, good job!

lazarlubomir
Contributor
Forum|alt.badge.img+7
  • lazarlubomirContributor
  • Author
  • Contributor
  • August 20, 2020
davtorgh wrote:

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

Nice one! Thank all for Your tips!

Reply


Helpful Members This Week

Community Stats

31,358
Posts
118,946
Replies
38,974
Members

Latest FME

Terms & ConditionsCookie settings

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
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.