Comparing Values when Imbedded newlines are present

Question

Hi Team,

I need your help.

I am trying to  compare the  "BillingStreet" Vs "Mailing Street". The problem i am encountering is around  "Imbedded newlines".

When trying to do the comparison on these records the compare is returning "False"

Example

BillingStreetMailingStreet9th Floor, Nirmal Building
Nariman Point9th Floor, Nirmal Building,
Nariman Point

Compare  Formula : IF [BillingStreet] = [MailingStreet] then "True" Else "False" Endif

Current outcome

BillingStreetMailingStreetStreetCompare9th Floor, Nirmal Building
Nariman Point9th Floor, Nirmal Building,
Nariman PointFALSE

Expected outcome

BillingStreetMailingStreetStreetCompare9th Floor, Nirmal Building
Nariman Point9th Floor, Nirmal Building,
Nariman PointTrue

Looking forward to your response

Regards

Masond3

DataNath · Answer

Have you tried playing around with the data cleanse tool? Might be your best option to standardise both fields ready for comparison - Particularly the Tabs, Line Breaks and Duplicate Whitespace option here: