Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
minor tweak needed for REGEX_INSTR
I am looking to pull a set of contact records where the last name begins with A, B, C, ... K (and lower case as well). Can anyone please tell me what is wrong with the following? It returns an error:
Formula(Numeric) = 1
CASE WHEN REGEXP_INSTR({lastname},'abcdefghijkABCDEFGHIJK',1) = 'T' THEN '1' END
Here's the equivalent enumerated in a CASE statement (this works):
CASE WHEN SUBSTR({lastname},1,1) = 'a' THEN 1
WHEN SUBSTR({lastname},1,1) = 'A' THEN 1
WHEN SUBSTR({lastname},1,1) = 'b' THEN 1
WHEN SUBSTR({lastname},1,1) = 'B' THEN 1
WHEN SUBSTR({lastname},1,1) = 'c' THEN 1
WHEN SUBSTR({lastname},1,1) = 'C' THEN 1
WHEN SUBSTR({lastname},1,1) = 'd' THEN 1
WHEN SUBSTR({lastname},1,1) = 'D' THEN 1
0