search

mortenbra / alexandria-plsql-utils

Oracle PL/SQL Utility Library
778 stars 316 forks source link

ora/csv_util_pkg.pkb function clob_to_csv: quoted newline characters? #87

Open u797595 opened 11 months ago

u797595 commented 11 months ago

Does function clob_to_csv ( orc/csv_util_pkg.pkb ) support quoted newline characters? (LF|CRLF, \n|\r\n)

https://datatracker.ietf.org/doc/html/rfc4180#page-2

"escaped = DQUOTE *(TEXTDATA / COMMA / CR / LF / 2DQUOTE) DQUOTE"

mortenbra commented 11 months ago

No, csv_util_pkg.clob_to_csv does not support quoted newline characters.

You might check out apex_data_parser.parse (see https://docs.oracle.com/en/database/oracle/apex/23.1/aeapi/PARSE-Function.html#GUID-B815CF74-C469-4F78-9433-643D1339E930 ) which is probably more standards-compliant.

anja8080 commented 7 months ago

Hi,

i think have the same problem with line breaks in quoted comments. actually your packages identifies this as a new column. but it's just a newline in a quoted comment. i would like to refere to this topic, where someone shared a workaround. but sadly it's not available anymore. Is there a chance to download this code somewhere?

https://code.google.com/archive/p/plsql-utils/issues/27