Apex 20.2 apex_data_parser seems to have a bug for parsing empty strings in a csv file. Steps to reproduce:
create table ttemp (content blob);
Now upload a simple file:
"1","","3"
"1",,"3"
select line_number, col001, col002, col003
from ttemp t,
table( apex_data_parser.parse(
p_content => t.content,
p_file_name => 't.csv' ) ) p
I would expect the same result for both lines, but the actual result is a single double quote in col002 for the first line:
1 1 " 3
2 1 3