Skip to main content
  • EN

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

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||'%'

 

 

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

I checked your Workspace, good job!

HI @lazarlubomir​ ,

 

InlineQuerier is the solution. See the atteched sample workspace.

 

Hope that helps!

Nice one! Thank all for Your tips!

Reply


Community Stats

30,162
Posts
114,483
Replies
37,810
Members
Terms & ConditionsCookie 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.