I need a windows desktop application that can read a directory of multiple, large CSV files that are about 150MB each and extract records based on specified column id and specified name.
Example... I want to extract all the records in each CSV that is contained column 18 (or State) and contains the term "Florida" in the column cell...
Here's how it works
After entering column name or id and term i.e. FLorida, the application will search each CSV file (one row at a time) and export all the data that has "Florida" in column 18 (named State) and save as file1.csv... then it opens [login to view URL] and exports all records to... file2.csv.... ect etc. until all files have been parsed and all data extracted.
Application should allow me to specify output folder so it does not overwrite original file name
Feel free to send me demo if you have one