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

I’m trying to get a saved search to give me anything in the Serial Number field that has spacing in the middle. Anyone know a formula for that?

are you using Advanced Bin / Numbered Inventory Management?

Ya I’m trying to disable it but it needs to clear any serial number with spaces or special characters 

for your original question, i might have recommended INSTR to give you the index of a character in a string

for your purposes, you probably want to upgrade to a regular expression

use REGEXP_INSTR to choose a regular expression

your original question i might have said choose something like `REGEXP_INSTR({inventorydetail.inventorynumber},' ')` to get the index of the first space in the serial

if you only want alphanumeric instead, you might choose `REGEXP_INSTR({inventorydetail.inventorynumber},'^[a-zA-Z0-9]*$')` and instead check that the index is 1

Wow thanks for all the info, I’ll give it a shot 