Wildcards for a field or alternatives

[TeodoraBurlica]

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!

[Nicolae_Alecu · Accepted solution]

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,