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
精彩评论