Getting values based on a string match in another table

[Rodriguez22]

Hi everyone,

I have a table with customers and multiple phone numbers:

Customer	Phone numbers
Jhon Smith	65214898 - 67845123 - 62315489 - 65421387
Marco Perez	69784951 - 69875123 - 69954871

I have another table with information of a call center (phone number and duration)

Number	Duration
67845123	00:02:32
65214898	00:01:20
69954871	00:04:11

I need to know the customers'name in the second table, for example:

Number	Duration	Customer name
67845123	00:02:32	Jhon Smith
65214898	00:01:20	Jhon Smith
69954871	00:04:11	Marco Perez

I have tried with TextBetween and MapSubString but don't work.

Any help with this is highly appreciated. 

Thanks!

[MarcoWedel · Accepted solution]

maybe like this?

mapCustomers:
Mapping
LOAD SubField([Phone numbers],' - '),
     Customer
Inline [
Customer, Phone numbers
Jhon Smith, 65214898 - 67845123 - 62315489 - 65421387
Marco Perez, 69784951 - 69875123 - 69954871
];


tabCallCenterInfo:
LOAD Number,
     Interval(Duration,'hh:mm:ss') as Duration,
     ApplyMap('mapCustomers',Number) as [Customer name]
Inline [
Number,	Duration
67845123, 00:02:32
65214898, 00:01:20
69954871, 00:04:11
];

[Rodriguez22]

It works!!!!! 

Thank you very much