EDI Question - Padding ISA and GS record with null Ascii 00 character

David Gollom Strategic Partner

• August 13, 2020 22:38

Hi Everyone,

We have a new requirement from our EDI partner. Currently, our ISA Id is a 10 digit number that's right padded with spaces to make the required 15 characters.  They now want us to right pad with "null" characters which are the ascii 0 (hex 00) charter.  I tried doing this with a NetSuite formula in the export search that feeds the flow.  RPAD('1233332222',15,NCHR(0)) which worked in NetSuite but then caused the EDI post to return an error.  

Is there a handle bar helper that might work?  I'm not sure how to feed a regex replace with that specific character. 

Thanks!!  

0

• 

  Celigo Integration Practice

  • August 14, 2020 00:01

  Hi David, Can you try updating NS formula to this RPAD('1233332222',15, '0')?

  0
• 

  David Gollom Strategic Partner

  • August 14, 2020 00:19

  

  

  

  

  

  I just tried that and I get the string padded with zeros. 

  "123333222200000"

  0

Please sign in to leave a comment.