Add Csv options to commands csv2html, csv2json, csv2xml, csv2excel, excel2csv
Preliminary option list :
- enable date quote identifier : []
- set string quote identifier : single, double, bracket
- set column separator : default ","
- set linefeed : default "\n"
- set null value : default : ""
- set datetime format
- set date format
- set time format
- set stream encoding = default UTF-8
All of options listed above are added to csv2* and execl2* commands. Backend transformer yet to be modified to support these options (logged as issue #7808).
-DQ : enable date quote identifier : []
-SQ : set string quote identifier : single, double, bracket
-d : set column separator : default ","
-l : set linefeed : default "\n"
-NT : set null value : default : ""
-PA : set datetime format
-PD : set date format
-PT : set time format
-c : set stream encoding = default UTF-8
Option names follow the naming conventions used by \sqlimport and \sqlexport.
Also added a -ED (--enable-date-quote) option, which is mapped to AquaCsvReader/Writer.enableDateQuotedString(boolean) method.
Note that linefeed option (-l) is not applied to csv2excel.
Removed -DQ|--date-quote option from all of csv2* commands. Date quote identifier is hard-coded to '[]' in reader and custom identifiers are not allowed. SVN r29846.
Removed -DQ|--date-quote option from all of csv2* commands. Date quote identifier is hard-coded to '[]' in reader and custom identifiers are not allowed. SVN r29846.
Verified in 12.0.1-2. Tested the new options.
Verified in 12.0.1-2. Tested the new options.
Issue #7809 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/29829, 29846 |
No time estimate |
All of options listed above are added to csv2* and execl2* commands. Backend transformer yet to be modified to support these options (logged as issue #7808).
-DQ : enable date quote identifier : []
-SQ : set string quote identifier : single, double, bracket
-d : set column separator : default ","
-l : set linefeed : default "\n"
-NT : set null value : default : ""
-PA : set datetime format
-PD : set date format
-PT : set time format
-c : set stream encoding = default UTF-8
Option names follow the naming conventions used by \sqlimport and \sqlexport.
Also added a -ED (--enable-date-quote) option, which is mapped to AquaCsvReader/Writer.enableDateQuotedString(boolean) method.
Note that linefeed option (-l) is not applied to csv2excel.