[
https://issues.apache.org/jira/browse/SANDBOX-263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647408#action_12647408
]
Henri Yandell commented on SANDBOX-263:
---------------------------------------
Excel on the Mac puts a comma in. I don't have it on Windows, but my suspicion
is that this might be a locale specific issue rather than Windows on the Mac
putting a semi-colin in.
There are also DOS CSV and Windows CSV options in the Save As - the only
difference appears to be newlines with the default CSV being the same as the
DOS CSV.
> Excel strategy uses wrong separator
> -----------------------------------
>
> Key: SANDBOX-263
> URL: https://issues.apache.org/jira/browse/SANDBOX-263
> Project: Commons Sandbox
> Issue Type: Bug
> Components: CSV
> Reporter: Gunnar Wagenknecht
>
> The Excel strategy is defined as follows.
> {code}
> public static CSVStrategy EXCEL_STRATEGY = new CSVStrategy(',', '"',
> COMMENTS_DISABLED, ESCAPE_DISABLED, false,
> false,
> false, false);
> {code}
> However, when I do a "Save as" in Excel the separator used is actually
> {{';'}}. Thus, parsing the CSV file as suggested in the JavaDoc of
> {{CSVParser}} fails.
> {code}
> String[][] data =
> (new CSVParser(new StringReader("a;b\nc;d"),
> CSVStrategy.EXCEL_STRATEGY)).getAllValues();
> {code}
> Simple test to reproduce:
> {code}
> import java.io.IOException;
> import java.io.StringReader;
> import org.apache.commons.csv.CSVParser;
> import org.apache.commons.csv.CSVStrategy;
> public class CSVExcelStrategyBug {
> public static void main(final String[] args) {
> try {
> System.out.println("Using ;");
> parse("a;b\nc;d");
> System.out.println();
> System.out.println("Using ,");
> parse("a,b\nc,d");
> } catch (final IOException e) {
> e.printStackTrace();
> }
> }
> private static void parse(final String input) throws IOException {
> final String[][] data = (new CSVParser(new StringReader(input),
> CSVStrategy.EXCEL_STRATEGY)).getAllValues();
> for (final String[] row : data) {
> System.out.print("[");
> for (final String cell : row) {
> System.out.print("(" + cell + ")");
> }
> System.out.println("]");
> }
> }
> }
> {code}
> Actual output:
> {noformat}
> Using ;
> [(a;b)]
> [(c;d)]
> Using ,
> [(a)(b)]
> [(c)(d)]
> {noformat}
> Expected output:
> {noformat}
> Using ;
> [(a)(b)]
> [(c)(d)]
> Using ,
> [(a,b)]
> [(c,d)]
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
