-
CSV filter
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?
-
Recent question here which may assist. Look at Posts 2 & 3
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
-
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 --
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules