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.
Please sign in to leave a comment.