mholt/PapaParse

encode null/missing values in unparse

Open

#350 创建于 2016年10月17日

在 GitHub 查看
 (5 评论) (0 反应) (0 负责人)JavaScript (11,877 star) (1,157 fork)batch import
good first issuehelp wantedsuggestion

描述

Hi papas,

CSV has no concept of null. You can't distinguish between empty strings and null. (good read: http://www.garretwilson.com/blog/2009/04/23/csvnull.xhtml)

Nevertheless, there are cases where you need to support both cases, so a solution might be to encode it as a special String like "NULL" or so (if its unlikely that this string will ever occure as a string in your app).

If you feed data where some fields are missing to papa.unparse, these fields will be empty in the resulting csv. is it possible to define another value for missing data, so that you could define "NULL" or similar for theses cases?

贡献者指南

技术栈
javascript
领域
data
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-3 hours
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
mostly clear
前置要求
basic JavaScriptunderstanding of CSV parsing
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
40
研究方向
Explore the unparse function in papaparse.js. The issue requests an option to encode null/missing values as a user defined string (e.g., "NULL") when outputting CSV. Review comments for discussion on implementation strategies and potential edge cases. No existing PR or assignee; maintainer has asked for clarification on desired behavior.