This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Dear, Need you help !

I’m trying to compare 2 text fields in a search to retrieve the difference. 

Is there a formula that can retrieve that difference ? 

Thank you for your help 

Use this 
CASE WHEN {field1} = {field2} THEN 'Match' ELSE 'No Match' END


If you need to compare the contents of two fields in a more complex way (e.g., finding which specific characters differ), you’ll likely need to use a script for that.

Can a map reduce resolve this error <@U04D95EGF97> ? 
What’s the job taitol?