[jira] [Created] (CSV-253) Handle absent values in input (null)

["Lars Bruun-Hansen (Jira)" <ji...@apache.org>]

Lars Bruun-Hansen created CSV-253:
-------------------------------------

             Summary: Handle absent values in input (null)
                 Key: CSV-253
                 URL: https://issues.apache.org/jira/browse/CSV-253
             Project: Commons CSV
          Issue Type: Improvement
          Components: Parser
            Reporter: Lars Bruun-Hansen


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:
{noformat}
    "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)
{noformat}
 

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...




--
This message was sent by Atlassian Jira
(v8.3.4#803005)