Uploaded image for project: 'Commons CSV'
  1. Commons CSV
  2. CSV-253

Handle absent values in input (null)

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.0
    • Component/s: Parser
    • Labels:
      None

      Description

      The parser must be able to handle absent values in input and translate that into null as required. I see several tickets on this matter in the history, but none seem to have addressed the issue, at least not for parsing.

      For this problem, I see a need to introduce a new term:

      Definition: Absent value is when there are zero characters between field delimiters.

      Specifically the aim is to be able to parse the following:

          "John",,"Doe"    // 2nd element is absent
          ,"AA",123        // 1st element is absent
          "John",90,       // 3rd element is absent
          "",,90           // 2nd element is absent (1st element isn't)
      

       

      See also CSV-93 which I think never addressed the issue, probably because the reporter was happy with having the issue fixed for CSV output, not for parsing.

      A PR is coming...

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lbruun Lars Bruun-Hansen

              Dates

              • Created:
                Updated:
                Resolved:

              Time Tracking

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

                Issue deployment