大批量数据的文件格式处理
现在有个csv文件其中有些字段的格式不合法:
"TestNo","TestDept","TestName","TestComments"
"0001","A001","zhang san","the first
c
ome
to work"
怎样能把换行去掉,把最后一列一行显示,只有最后一列需要处理?
"TestNo","TestDept","TestName","TestComments"
"0001","A001","zhang san","the first come to work"
------解决方案--------------------
你可以StreamReader遍历读取,然后如果开头没有引号,就删掉前面的换行