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

Integrator.io
, , ,
1

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!!

2

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

3

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

"123333222200000"