Matching of Complex String with varying sequence

[Oreoluwa]

I would like to match a substring list with a string list.

For example, I have a list that contains unique identifiers. e.g. CM1.EF336X803; CM1.EF337X817; CM1.EF337X072 

I have another list that includes a longer string that includes the sub string + other texts but this substring does not follow any particular order and may vary in length. e.g

EXSSP5|022023 EOP Cut-off | INV # XU-OFFSET CM1.EF336X803F | Line # 00001 | SEQ # 167916|

G24561 | 219 | | | | | PGSSP2 | COST LIQUIDATION CM1.EF337X817

G24561 | 219 | | | | | CM1.EF337X072 | COST LIQUIDATION 

How can I return a sub string from the substring list in a seperate colomn that is contained within the main string list? 

[binu_acs · Accepted solution]

@Oreoluwa One way of doing this

[Oreoluwa]

Thank you! Not so complex afterall 😊