Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to CSV - triming leading zeros

aPsikusApr 26 2018 — edited Apr 27 2018

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details