SQR - Output CSV with leading 0s question - Tools 8.59.03
Hello,
I am trying to output a CSV and maintain the leading 0s on employee IDs, I was able to successfully maintain the 0s by using this code:
let $emplid = '="' || $emplid || '"'
but when the CSV is pulled in by the vendor, their program is grabbing ="000001" because while the CSV displays just the numbers, the data itself has =" " included. So I'm wondering if anyone has figured out how to output a CSV and maintain the leading zeros without using the above method.
Thanks,
Jeff