Hi,

I'm new to Netsuite and so im still learning the basics.

Our integration partners create a saved search and used a formula field "SUBSTR({custbody_pacejet_shipped_method}, 1, INSTR({custbody_pacejet_shipped_method}, ' ') - 1)"

I was able to locate this field on the Transaction Body Field, but i cannot find the script where the logic behind this field is. Im trying to modify the values that are displayed in the saved search.

For context, we have a field that stores a carrier and shipping method in one. I need the saved search to display the carrier in 1 field and the shipping method in another but i also need the shipping method to display in a certain way that would be accepted by a 3rd party system that is integrated. For example, if the field value is currently "FedEx Ground" I need to saved search to show carrier "FedEx" and shipping method "FedExGround". I have a table of accepted values that im hoping to create a IF/THEN statement in order to