windows command to extract data from specific columns in a .csv file
- Sean O'Shea
- Apr 25, 2020
- 1 min read
You can use a Windows command to extract data from specified columns in a .csv file.
In this format:
for /F "tokens=2,3,4,5,6 delims=," %i in (Fielding.csv) do @echo %i,%j,%k,%l,%m >> output.csv
. . . the tokens specify the numbers of the columns from which data should be extracted. The script specifies the file to pull data from and at the end lists an output file.

Open command prompt in the folder containing the source file. Enter this script and press return. A new .csv file will be generated that contains data from just five of the columns from the source file.

Note that this will not work if you try to select data beyond the 31st column in the .csv file.
Recent Posts
See AllWhen using robocopy command in Windows to copy files, note that if you are an admin you can use the /B switch to copy files from...