Wildcards for a field or alternatives

TeodoraBurlica — Thu, 30 May 2024 11:22:54 GMT

Hello,

I have this wildmatch function: if(wildmatch(field1, '*1234*', '*12345*'), 'ok', 'nok') and I wonder if the hardcodes can be replaced with a field from the database, but work on the same principle with *.

I know that wildmatch(field1, *field2*) doesn't work. Is there any alternative?

Field1 is a field with several concatenated codes, and I want to match with the other field that has just one code.

Thanks!

Re: Wildcards for a field or alternatives

Nicolae_Alecu — Thu, 30 May 2024 12:16:54 GMT

Hello,

IF(WILDMATCH(field1,'*'&field2&'*'),'Ok','Nok')

Code:

A:
Load 
field1,
field2,
if(Wildmatch(field1,'*'&field2&'*'),'Ok','Nok') as WildMatch
Inline [
field1 , field2
1-01-1,01
2-02-2,02
3-01-3,03];

Output:

Best Regards,

topic Wildcards for a field or alternatives in App Development

Wildcards for a field or alternatives

Re: Wildcards for a field or alternatives