Searching large excel files
Hi,
Can someone suggest me a tool that can search huge excel files like a
database and display/print results? I have CSV files with thousands of
records. I want to search rows based on a specific criteria that
involves different columns and conditions.
For example:
[Column A between 6/1/2000 and 6/1/2007] AND [Column B like '%thakershi
%' or Column B like '%shah%'] AND [Column C = $60,000]
This is just one example. The conditions keep changing based on what
is required.
Any help is welcome.
Thank you.
Malay Thakershi
|