search & remove value

[yeruvab]

how to remove a value which is equal to same value in other column?

example: col1 has ABC

col2 has ABC,DGH,HYG

so output should be DGH,HYG

Thank you!

[Deano478]

@yeruvab for this specific use case above I tested and you can use the formula: 

REGEX_Replace([Col 2], "\b" + [Col 1] + "\b,?", "")

[yeruvab]

its giving the same values which is in col2

[Deano478 · Accepted solution]

See the WF attached is gives the output of DGH,HYG

[yeruvab]

Yes!! works like charm!! Thank you 

[Raj]

@yeruvabPlease accept @Deano478's solution if it resolves the issue. This will assist others and help address pending challenges.

Regards,

Raj