NSC | Using Special Characters in REGEXP Formula Patterns

Scenario

User needs to use a special character (such as period, asterisk, plus sign) in a REGEXP formula.

In REGEXP, special characters are used to define patterns for searching and matching within strings.

For example:

• Period (.): Matches any single character except newline.
• Asterisk (*): Matches zero or more occurrences of the preceding element.
• Plus Sign (+): Matches one or more occurrences of the preceding element.

Solution

To include special characters in a regular expression (REGEXP) formula in NetSuite Saved Search, you typically need to escape those characters with a backslash (\) to ensure they are treated as literals rather than special characters in the regular expression pattern.