How to Accurately Compare NetSuite Text Area Fields in SuiteScript?

To accurately compare text area fields, such as shipping addresses on a customer record, a robust SuiteScript technique involves normalizing the strings before comparison. This method accounts for variations in whitespace and other non-visible characters that might otherwise cause discrepancies. In the following example, newRecordShipAddress and oldRecordShipAddress are objects, and their respective .text properties hold the actual strings to be compared.

First, define a regular expression to target whitespace and the enquiry character:

javascript
var REGEX_REMOVE_SPACES_AND_ENQUIRY = /s|x05/g;

The regular expression REGEX_REMOVE_SPACES_AND_ENQUIRY is designed to remove all whitespace characters (s) and, to ensure consistent comparison, potentially present non-visible characters like the enquiry character (x05). While the automatic presence of the enquiry character may vary depending on field configuration or NetSuite version, its removal helps standardize the strings for accurate comparison.

Next, process the new record's text:

javascript
var trimmedNewShipAddress = '';
if (newRecordShipAddress.text != null) {
        trimmedNewShipAddress = newRecordShipAddress.text.replace(REGEX_REMOVE_SPACES_AND_ENQUIRY, '');
}

Similarly, process the old record's text:

javascript
var trimmedOldShipAddress = '';
if (oldRecordShipAddress.text != null) {
        trimmedOldShipAddress = oldRecordShipAddress.text.replace(REGEX_REMOVE_SPACES_AND_ENQUIRY, '');
}

These trimmed strings can then be used for reliable comparison.