Netsuite saved search criteria filter, formula to check when {item} contains “-N”

AI generated answer (using internal Slack threads):

In NetSuite Saved Search, you can use SQL-like syntax in the formula field to check if an item contains a specific string. In your case, you want to check if the item contains "-N". You can use the

LIKE

operator in the formula field to achieve this. The

LIKE

operator is used in a WHERE clause to search for a specified pattern in a column. Here is an example of how you can do this: 1. Go to the Criteria tab in your Saved Search. 2. Click on

Formula (Text)

from the drop-down menu. 3. In the formula field, enter the following formula:

CASE WHEN {item} LIKE '%-N%' THEN 1 ELSE 0 END

4. Set the operator to

equal to

and the value to

1

. This formula will return 1 when the item contains "-N" and 0 when it does not. By setting the operator to

equal to

and the value to

1

, you are filtering out all items that do not contain "-N". Please note that the

%

symbol is used as a wildcard in SQL. It means "any number of any characters". So,

%-N%

will match any string that contains "-N" anywhere in it. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******