Removing a suffix of a string

Anek Porwal Strategic Partner NetSuite Integration Whiz

• April 29, 2022 05:43

Hello Everyone,

I'm a Newbie to the Celigo IO Platform.
I am Creating an Item Fulfillment Record from 3PL Shippment Document to NetSuite.
The 3PL appends T in front of a Sales Order Number Example (TSO00001).
I want to remove the T appended in the Shipment Document Field.
How can I accomplish this? 

0

• 

  Matt Graney Chief Product Officer

  • April 29, 2022 05:59

  

  

  

  If it's always just a single character prefix, you can use the substring handlebar in your mapping to strip it:

  {{substring id 1 id.length}}

  The above syntax takes the field "id" and returns everything but the initial character (the 0th character).

  References:
  the substring function
  using handlebars in mapping 

  1

Please sign in to leave a comment.