Every week, we get an export of data from our vendor in CSV format that shows these columns:
These get stored in G:\Historical Data in the format <date>.csv, e.g. 01-25-2013.csv
Sometimes, we get a query from our users saying, when was the last time we had a certain Product (e.g. Battery) listed under SAP Code=141 . We need a way to query all these CSV files and state the last time
Product was equal to Battery
SAP Code was equal to 141
Is there a Powershell that can do that? Running Windows 2008 Server.