This should be an easy project. The goal is to do some simple processing to a batch of CSV files:
For each CSV file in specified directory:
(Example, for a file named: [url removed, login to view])
Delete all columns except FIRST COLUMN
Delete ROW 1 of remaining column
Remove all double quote marks and all open and close bracket symbols: " [ ]
Remove all dashes and ".csv" from file name to get keyword phrase to search for ([url removed, login to view] -> custom wine glasses)
Search for that keyword phrase in the remaining column in the csv file:
- if found, move it up to ROW 1 (making sure to delete that empty row)
- if not found, add it to ROW 1 (i.e. insert row at beginning and add the keyword phrase)
Save the file into a specified folder (a subfolder in current directory)
Repeat with rest of CSV files in directory
This can be done in Windows or on a server (PHP or whatever).
See attached CSV files for example.