top of page

windows command to extract data from specific columns in a .csv file

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.

bottom of page