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

Hi all! I would like to use REGEXP_SUBSTR to string in {memomain}. Can someone help and tell me how i would get:
`Example company Plc`
From String
`Migration invoice. Original invoice id: 12345 for customer: Example company Plc`

I think I need to find either the second `:` or then `customer:`  and select everything after that.

Thank you!

probably want to ask in <#C2A1ZEMF0|>. Unless you want to learn about how negative lookahead doesnt work in sql, i suggest using <https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions068.htm|INSTR> and/or <https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions162.htm|SUBSTR>

alternatively you probably want <https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm#i1305521|REGEXP_REPLACE> if you really want a regular expression in there

Ok, thanks! And I just realized I didn't mentioned that I mean Saved Search where I would need this.