Using WildMatch and another field as the expression

[dawgfather]

I am trying to see if there is a way to use another field within a LOAD in a WildMatch function.

I have a field that contains a number and some other characters like "1234_testing_iso" or "12345_impala_pad" and then I have another field which is essentially a cost code such as "1234" or "2345".

I am trying to see if I can make a WildMatch function using the second field as the expression to reference.

Field1 = 1234_testing_iso or 12345_impala_pad

Field2 = 1234 or 12345

What I had in mind would be something like:

IF(WIldMatch(Field1,'*(Field2)*'),'Match','No Match')

If it was comparing "1234_testing_iso" to field 2 (1234) there would be a "Match". Comparing it to (2345) would get "No Match".

Comparing "12345_impala_pad" to (1234) would be a "Match" and compared to (2345) would also be a "Match"

Ideas?

[sunny_talwar]

I think you might need to use MapSubString here