Filtering A CSV file during the import
Answer to your question is yes. What determins the data that you dont need ?
What column is it in ? Maybe post some or all of your code so I can or
someone can may be able to help you.
"Steve White" wrote:
I have a situation where a .CSV files(approx 380,000 rows) containes a lot of
data that I do not need. being rather new to scripting I am unsure how to
get this loaded properly. I has found ways to split the file and to have it
import into multiple sheets where I may then manually scrub to the data I
need. I was wondering if it is possible to select only the rows in the CSV
file that I need on the way in thereby saving me a lot of time by not having
to manually scrub the 300,000 rows I do not need.
I do not have access available to me for any of this and I only have Excel
2003(hence the splitting and mutiple worksheets).
Is this possible at all?
Thank,
Steve
|