I need remove the entire value starting with matched value in other column, let me know for further questions. TIA
Col1 | Col2 | EXPECTED |
XYNTHA, XPOVIO | XYNTHA SOLOFUSE | XPOVIO |
FLUTHOX DR, NATESTO, VOGELXO | FLUTHOX HCL | NATESTO,VOGELXO |
BUPROPION HCL, BUPROPION HCL SR | BUPROPION XL |
|
SULFACETA SODIUM | SODIUMSULFACETA |
|
Solved! Go to Solution.
Hi @yeruvab ,
The 4th row makes the issue harder as it is not clear which "word" should be checked.
So I relaxed the problem to deal with only the words separated by space, instead of any possible length of the string in Col2.
I hope this helps.
Input
Col1 | Col2 |
XYNTHA, XPOVIO | XYNTHA SOLOFUSE |
FLUTHOX DR, NATESTO, VOGELXO | FLUTHOX HCL |
BUPROPION HCL, BUPROPION HCL SR | BUPROPION XL |
SULFACETA SODIUM | SODIUM SULFACETA |
Output
RecordID | Col1 | Col2 | Expected |
1 | XYNTHA, XPOVIO | XYNTHA SOLOFUSE | XPOVIO |
2 | FLUTHOX DR, NATESTO, VOGELXO | FLUTHOX HCL | NATESTO,VOGELXO |
3 | BUPROPION HCL, BUPROPION HCL SR | BUPROPION XL | |
4 | SULFACETA SODIUM | SODIUM SULFACETA |
Workflow
Thank you for your answers, helped me understand how to solve such tricky scenarios.