commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary D. Gregory (Jira)" <j...@apache.org>
Subject [jira] [Commented] (CSV-253) Handle absent values in input (null)
Date Tue, 29 Oct 2019 14:28:00 GMT

    [ https://issues.apache.org/jira/browse/CSV-253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16962053#comment-16962053
] 

Gary D. Gregory commented on CSV-253:
-------------------------------------

Hi [~lbruun]

Thank you for your PR.

We already have a setting which you could reuse for this: {{org.apache.commons.csv.CSVFormat.nullString.}}

May you try to use this setting instead of creating a new one?

 

> 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
>            Priority: Major
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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)

Mime
View raw message