Comparing Values when Imbedded newlines are present

[Masond3]

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 

BillingStreet	MailingStreet
9th Floor, Nirmal Building Nariman Point	9th Floor, Nirmal Building, Nariman Point

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

Current outcome 

BillingStreet	MailingStreet	StreetCompare
9th Floor, Nirmal Building Nariman Point	9th Floor, Nirmal Building, Nariman Point	FALSE

Expected outcome 

BillingStreet	MailingStreet	StreetCompare
9th Floor, Nirmal Building Nariman Point	9th Floor, Nirmal Building, Nariman Point	True

Looking forward to your response 

Regards

Masond3

[DataNath]

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: