Hi everyone
I recently upgraded from APEX 5.0.3 to APEX 20.2 and since then I have an issue when downloading a table as a .CSV file
The tables have many columns and each column contains either text, (decimal) numbers or Null values that are shown in APEX as - (dash) with the APEX functionality (Attributes => Appearance => Show Null Values AS - )
The table below is just an example with 10 columns (separated with | (pipe)) to give you an idea.
Example:
Max | Muster | 1500 | USD | 2.25 | - | 13.02.2021 | - | - | A
Felix | Muster | 2300 | CHF | 3.25 | 1 | 26.07.2021 | IN | CN | D
Moritz | Max | 4500 | EUR | 4.20 | - | 16.08.2021 | - | - | C
CSV Output:
Max,Muster,1500,USD,2.25,,13.02.2021,,,A
Felix,Muster,2300,CHF,3.25,1,26.07.2021,IN,CN,D
Moritz,Max,4500,EUR,4.20,,16.08.2021,,,C
Standard download in APEX 20.2 loses the dashes!! I wonder why.
I would expect the following result in the .CSV file:
Max,Muster,1500,USD,2.25,-,13.02.2021,-,-,A
Felix,Muster,2300,CHF,3.25,1,26.07.2021,IN,CN,D
Moritz,Max,4500,EUR,4.20,-,16.08.2021,-,-,C
Does anyone have a solution for it. We have many reports with up to a 100 columns and we need the dashes in the file. I do not want to add the dash afterwards in the .CSV file nor would I replace the - with any other (special) character.
Best regards,
Tom