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, anyone good with regex_substr because I have been struggling with this save search formula. I got one half, but can't get the other.  I am trying to pull out string after the space "1234 test corporation"
```REGEXP_SUBSTR ('1234 test corporation', '(\S*)(\s)')        -  Successfully pulls  1234
REGEXP_SUBSTR('1234 test corporation',  '[^\s]+$')     - pulls  't corporation'     I see that it's pulling everything after the first 's', but I'm not sure why exactly.  I want it to return 'test corporation'```

if you want to give up, you dont actually need a regular expression to do this

you can just get the position of the first space and use regular substrings

if you want to keep on going, then you need to know that your second attempt is the same as
```REGEXP_SUBSTR('1234 test corporation',  '[^s]+$')```

wow you are right I was just able to use substr and instr. I don't use those often so didn't even think about them