当前位置: 主页 > 日志 > 其它 >

CSV字段值需要quoted的几种情况

在CSV文件中, 以下几种情况字段值需要用半角双引号(即"")将该字段值包含起来(下面简称quoted):

来源:http://en.wikipedia.org/wiki/Comma-separated_values

 

1)Fields with embedded commas must be quoted.(当字段值中包含有半角逗号时,整个字段需要quoted),例如:

 1997,Ford,E350,"Super, luxurious truck"

 

2)Fields with embedded double-quote characters must be quoted, and each of the embedded double-quote characters must be represented by a pair of double-quote characters.(当字段值中含有半角双引号时,整个字段需要quoted,并且被包含的每一个半角双引号都要被替换成一对半角双引号),例如:

 1997,Ford,E350,"Super, ""luxurious"" truck"

 

3)Fields with embedded line breaks must be quoted (however, many CSV implementations simply do not support this).(当字段值中有换行是,整个字段需要quoted。然而很多CSV模块的实现都不支持字段内有换行。PS:Python是支持的),例如:

1997,Ford,E350,"Go get one now
they are going fast"

 

4)In CSV implementations that do trim leading or trailing spaces, fields with such spaces as meaningful data must be quoted.(字段值需要以空格开头时,整个字段需要quoted),例如:

 1997,Ford,E350," Super luxurious truck "

[日志信息]

该日志于 2012-02-19 09:19 由 redice 发表在 redice's Blog ,你除了可以发表评论外,还可以转载 “CSV字段值需要quoted的几种情况” 日志到你的网站或博客,但是请保留源地址及作者信息,谢谢!!    (尊重他人劳动,你我共同努力)
   
验证(必填):   点击我更换验证码

redice's Blog  is powered by DedeCms |  Theme by Monkeii.Lee |  网站地图 |  本服务器由西安鲲之鹏网络信息技术有限公司友情提供

返回顶部