CSV filter

[jjj2k]

Hi there guys!

I have a CSV file with over 15million rows which weighs about 3.15GB. Needless to say I can't open it on excel but I don't need all the data anyway.

The rows start with either DA or DH in the first column. I want a batch script or something that will extract rows starting with DH only.

Any suggestions on how I can do it?

[mdmackillop]

Recent question here which may assist. Look at Posts 2 & 3

[Tinbendr]

Also an article here.

[jjj2k]

Thanks guys for your suggestions.

I did it using a windows batch file (thank god it was a CSV)

-- start of batch file --
@echo off
for /f "tokens=* delims=," %%a in ('findstr /B "DH" C:\temp\GTAM2310.002') do echo %%a >> C:\temp\testM1.csv
- end of batch file --