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

Any tips on using REGEXP_SUBSTR()? I'm trying to identify lines with non-ascii characters, but can't get the following to work:

REGEXP_SUBSTR({memo},'/[^\x00-\x7F]/g')

(for others in <#C2A1ZEMF0|>) <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1684860515270529|answered in #general>

REGEXP_SUBSTR({memo}, '[^' || CHR(1) || '-' || CHR(127) || ']')