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.


Recent Posts

See All
backup mode for robocopy

When 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...

 
 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page