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 am trying to do something like this SUBSTR({trackingnumbers}, 1,INSTR({trackingnumbers}, ' ')-1), but nothing is happening

Okay , I have got it, I have three variations of this
I have sourced with formula

CASE
WHEN RTRIM(SUBSTR({trackingnumbers}, 1,11),' &lt;') = RTRIM(SUBSTR({trackingnumbers}, 1,12),' &lt;') THEN RTRIM(SUBSTR({trackingnumbers}, 1,11),' &lt;')
WHEN RTRIM(SUBSTR({trackingnumbers}, 1,12),' &lt;') = RTRIM(SUBSTR({trackingnumbers}, 1,13),' &lt;') THEN RTRIM(SUBSTR({trackingnumbers}, 1,12),' &lt;')
ELSE RTRIM(SUBSTR({trackingnumbers}, 1,18))
END