You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Lars Bruun-Hansen (Jira)" <ji...@apache.org> on 2019/11/05 17:59:00 UTC
[jira] [Commented] (CSV-253) Handle absent values in input (null)
[ https://issues.apache.org/jira/browse/CSV-253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967731#comment-16967731 ]
Lars Bruun-Hansen commented on CSV-253:
---------------------------------------
Hi,
Any news on this one ? (and its associated [PR 51|http://example.com]).
I'll be happy to answer more questions, provide more details, change the PR, etc.
> 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
> Attachments: 2019-10-30 20_31_39-Apache Commons CSV 1.8-SNAPSHOT API.png, Parser-setting-absentIsNull-Javadoc.png
>
> Time Spent: 0.5h
> 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)