I would like a Windows script to be able process CSV files. Attached are instructions and examples files.
1) Open working file (example: [url removed, login to view])
Each row contains a domain name (column A) and the name of a csv file (column B) corresponding to that domain name.
2) Go through each row of this file, open the corresponding csv file in colum B. (example: for row 1, open [url removed, login to view])
The csv file to be processed has a blank column A and column B with a key word phrase per row.
3) For the csv file (example: [url removed, login to view]), go through each row and do the following:
- take the domain name (from working file) and append the keyword phrase (column B) and then append ".html" to it, then replace all spaces with "-" (dash)
- Example: Row1: [url removed, login to view]
- insert this for that row in the blank column A
- repeat with each row until the end of csv file
4) Save the file (now with column A filled in) - Note save with same name (don't save as separately named file)
See "[url removed, login to view]" for example of finished processed csv file.
5) Open file "[url removed, login to view]" and append the data from the processed file. Note, this file will keep getting longer as you append the dafa from each processed csv file (see example file "[url removed, login to view]")
6) Repeat for each row in working file ([url removed, login to view]) until the end.
In the end, all the CSV files will have column A filled in and you will have long CSV file containing all the data from all the CSV files that were processed.