Search code examples
netsuitesaved-searches

Netsuite saved search extract first six characters

I'm trying to extract first six characters from a field using NetSuite saved search expression. Example if the field "DCBB18-271-LG" I want the result to only display "DCBB18"

Thanks!

Imran

Solution

  • You should be able to use the SUBSTR expression within a Formula (Text) Result column to accomplish this.

    For example, if you wanted the first six characters of the field {upccode}, then your formula would look like:

    SUBSTR({upccode}, 0, 6)

    You can check out the other SQL functions you can use in formulae by checking the NetSuite Help page titled SQL Expressions.

    HTH