如何将.CSV文件每列分割成一个文件？

iocg

我想将csv文件按列分割文件
1.csv 用excel打开

用文本编辑器打开

1. iocg1,iocg2,iocg3,iocg4,iocg5
   
2. 100,200,,",100,200,300,","""100,""200,""300"""
   
3. 200,,",100,200,300,","""100""200""300""",100
   
4. ,"""100,""200,""300""",,,",100,200,300,"
   
5. ",100,200,300,",,,200,"""100,""200,""300"""
   
6. """100,""200,""300""",,200,,",100,200,300,"

复制代码

如图，得到iocg1 ~ iocg5 命名的5个文件，内容从第二行开始？

yestreenstars

你转CVS文件是能不能选择用制表符来分割？

xdxduser

awk？
可以把CSV每一行中各列之间的分隔符改成其他符号吗？
直接用vim读取默认已经是“，”了，你可以改成别的不会造成混淆，再用awk进行分割