5 Replies Latest reply on Apr 27, 2018 7:46 AM by Joel Acha

    Export to CSV - triming leading zeros

    aPsikus

      Hi,

       

      I have looked for similar issues on forum, but there is no working solution.

       

      I have report with Postal code column. In RPD it is varchar, as in some of the countries postal code is alphanumeric.

       

      We would like to share results with greater audience, and we are using Agent/IBot to send mails with attachment. Extract file is too big for Excel, and we need to use CSV format, but in this format values with leading zeros are treated as number and zeros are trimmed.

       

      I haven't found any working solution which will avoid trimming leading zeros.

       

      Do you have any suggestion how it can be solved?