Skip to main content

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