Skip to Main Content

APEX

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 for Null Columns

JessicaWilsonNov 10 2020

We just upgraded from Apex 5.1 to 20.1 and noticed a changed behavior that I'd like to figure out how to get back to the original. The problem is that now in a Classic Report "Export to CSV" feature, NULL columns are exported as space (" ") instead of an empty string (""). Is there any known way to get back to the empty string functionality? I have users that have built macros around the old file format and are squawking about this change. I've tried stripping HTML with no success and that was the only setting I saw that might influence this. I'd really like to avoid custom coding a new export for them.

This post has been answered by Patrick Wolf-Oracle on Nov 11 2020
Jump to Answer
Comments
Post Details
Added on Nov 10 2020
11 comments
1,595 views