Uploaded image for project: 'Daffodil'
  1. Daffodil
  2. DAFFODIL-1923

Excel export CSV escaping - can't be handled with standard block escape

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: Back End
    • Labels:
      None

      Description

      Excel spreadsheet looks like this:

      1 2 This is "some fun" now 3

      When exported to CSV, this is created

      1,2,"This is ""some fun"" now",3
      

      Notice the quotations around the string, and the doubling of the quotes inside the string as an escaping mechanism.

      One would think that an escape scheme with kind 'escapeBlock' with the block start, block end, escape and escapeEscape all defined to be '"' (doublequote) would work, but it does not.

      Error message is a PE indicating "delimiter not found".

      I am only 60% sure of this bug. It came up in a project using CSV data exported from excel, but other complexities there may have been interacting.

      Isolated test case is needed to really verify the behavior.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dfthompson Dave Thompson
                Reporter:
                mbeckerle Michael Beckerle
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h