Reverse wildmatch

[William2]

Hey community, 

Is there a way of this wildmatch?

Wildmatch(field1&'*', "value1","value2","value3")

The values contain field1 but longer like 

Field1  ; value1

New  ;  Newyork 

Is this a valid way to use wildmatch? Wildmatch will be used in set analyses.

Greets and thank you.

[stevejoyce]

I guess if you want to match if values1-3 begin with field1, you can do this...

=match(field1, left(value1, len(field1)), left(value2, len(field1)), left(value3, len(field1)))

or you could use substringcount/index if you wanted to find if it was contained in the middle.

[William2]

Thanks for reply. Hoped there was an easier work around. I have like 10.000 values to compare and duo to perfomance I try to use set analyses. I found an other way to solve my problem. Thanks