csv文件在Windows出现乱码

Question

1.如下数据在liunx数据库中正常显示,导出到的csv也正常,但是拷贝到windows下会出现乱码

db.foo.bar.find()
{
"_id": {
"$oid": "575bb9694d62257f6b000000"
},
"no": 1,
"sn": "DLXQL00UH0K0",
"status": "PASS",
"name": "张三\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000001"
},
"no": 2,
"sn": "DLXQL012H0K0",
"status": "PASS",
"name": "李四\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000002"
},
"no": 3,
"sn": "DLXQL01AH0K0",
"status": "FAIL",
"name": "王五\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000003"
},
"no": 4,
"sn": "DLXQL019H0K0",
"status": "PASS",
"name": "赵六\r"
}
Return 4 row(s).
Takes 0.2240s.
复制代码

导出的CSV：

no,sn,status,name
1,"DLXQL00UH0K0","PASS","张三^M"
2,"DLXQL012H0K0","PASS","李四^M"
3,"DLXQL01AH0K0","FAIL","王五^M"
4,"DLXQL019H0K0","PASS","赵六^M"
2.csv (END)
复制代码

但拷贝至Windows下会出现如附件1.png所示的乱码

2.上传和下载的数据中一直出现分隔符 "张三\r" "张三^M",如何消除?

Answer 1

1、乱码可能是因为操作系统之间文件格式不同而导致，可以尝试参考该博客http://blog.csdn.net/zhangyang0402/article/details/5153649
2、记录当中的分隔符推测可能是因为录入记录的时候，忽略了应该去除字符串末尾的换行符。