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?
Solved! Go to Solution.
Thank you! Not so complex afterall 😊