wildmatch with 2 fields of different tables

[bensca04]

Hi experts,

I need some help. I have a list of customer numbers (e.g. 19156) and a list of transaction numbers (e.g. 400191560169) . The customer number is included in the  transaction number. Now I want to find the customer of a transaction.

I could make a join of both tables and than a wildmatch like this

Result:

noconcatenate LOAD *

Resident Source

where WildMatch(transaction, '*' & customer& '*')

The problem is that the tables have 1000000 and 3000000 lines. A join of both tables is not possible (1000000*3000000 lines). 

You have any other idea to solve this problem?

[sunny_talwar]

May be using MapSubString() with Mapping Table to do this?

[bensca04]

Thanks a lot. This should work.

Now I can match the customer name into the transaction number. Now I have something like this: 4004customer48905

I want to have only the customer without the numbers around it. You know how to fix this? The number of digits is variable, so I can´t use the mid-function.

[sunny_talwar]

I am not sure I follow...