开发者

How to delete a certain column (s) from big csv file in Windows?

The files sizes m开发者_开发百科ight be over 1GB. I can write a script, but I wonder if there is a simple way, for example using Windows Command Prompt?


I used the following solution:
1. Install FileUtils package from GnuWin32 project.
2. run command in command promt:

cut -f<idxColumn> --complement -d,  <inputFile>  >  <outputFile>


For example:

cut -f3 --complement -d, d:/in.csv > d:/out.csv

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜