Match Names from other Table

[Necator]

Hello,

I got a table with names, lets say:

Adam

Bert

Ceasar

Doris

Eva

Additionally I got a dataset which includes one column, where those names are part of, eg.

Column1	Name Column	Column 3
xyz	ENG Adam 135	qwer
xyz	FRA Doris 657	qwer
xyz	8945 USA Eva	qwer
xyz	ENG 23612/Caesar	qwer

As you can see, the values in the second column aren't always following the same logic, so I can't use Subfield etc.

Is there a way to get to the following outcome:

Column1	Name	Column3
xyz	Adam	qwer
xyz	Doris	qwer
xyz	Eva	qwer
xyz	Caesar	qwer

Thanks

[anat]

can you try using Mapsubstring function.

https://community.qlik.com/t5/QlikView-App-Dev/Mapping-of-strings-mapsubstring-replace/m-p/1736142

[Necator]

The first table with the names is a field from another table, so I have to resident load, instead of Inline. Sadly it seems not to work.