Hi
I have a csv file with the following 2 rows. The data is delimited with comma
NA-40á,RL01830,01551,CT4101020,2223010,EB.04.01.ZV,
NA-40ü,89303018SAU000006,01551,CT4101030,2223011,EB.04.01.ZW,
I am using this to read the data and insert each cell value to table column
file_table f, TABLE (apex_data_parser.parse (p_content => f.the_file,
p_add_headers_row => 'N',
p_xlsx_sheet_name => null,
p_file_name => f.file_name
))
For the 1st cell which have NA-40á, when I look into the table column, I found this, which is the 1st and 2nd cell combined.
So surpised why the delimiter is not working in this case.
This is not happening with the 2nd row. It is correctly splitted and inserted into table column.
Any idea?
Thank You
Debraj