开发者

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

开发者 https://www.devze.com 2023-03-20 03:40 出处:网络
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:

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

精彩评论

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