Iam currently using a workbook to write the data, and require trailing zeroes in a column. I used padleft to write the trailing zeroes. It’s working fine with workbook activities.
But when trying to copy the same data to CSV, it’s completely failing. The trailing zeroes are being formatted. Any help on this would be appreciated
Include double quotes so that in cav parsing it considers as one string and will not change
Also check the csv opening it as text
Cheers
The data is sensitive and need to be uploaded to third party app and this approach didn’t work.