Compare Old String & New String Columns and Output the Unique Substring into a New Column

[Rahulkanth]

Hi Team, I have 2 columns Old and New which contains Text, and each substring is separated by pipe. I would like to compare the Old & New Columns and output the only substring which is unique in nature from New Column. I have created a sample data for your reference.

Old	New	Expected Output
	Abc(123)	Abc(123)
Abc(123)|Bdc(321)	Abc(123)|Hij(432)|Bdc(321)	Hij(432
Kna(987)|Hij(432)|Abc(123)	Pnr(0071)|Abc(123)|Kna(987)|Gfd(091)	Pnr(0071)|Gfd(091)
Hij(432)|Abc(123)	Hij(432)|Akr(779)	Akr(779)

Kindly help me on this request, thank you for your support.

[nagakavyasri · Accepted solution]

@Rahulkanth Try this: