如何將.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,"

復(fù)制代碼

如圖，得到iocg1 ~ iocg5 命名的5個文件，內(nèi)容從第二行開始？

yestreenstars

你轉(zhuǎn)CVS文件是能不能選擇用制表符來分割？

xdxduser

awk？
可以把CSV每一行中各列之間的分隔符改成其他符號嗎？
直接用vim讀取默認已經(jīng)是“，”了，你可以改成別的不會造成混淆，再用awk進行分割