I need someone to build me some type of CSV tool that will allow me to:
#1 tell it which text I want to search for and replace in the csv file
#2 let me input a new list of different texts that I want to replace the old text with
#3 starting with the first text, search and replace, then generate a new csv file. then search and replace and generate a second file. etc, etc
basically what it boils down to is I have a CSV file that needs to be duplicated many times, and I need to be able to give the program a text to start with, and then have it generate a new file for each text that I input into the list that I talk about in #2. I will need it for different types of csv files, so it cant be set to only work with the file that I attach.
If you look at the csv file, I would want to replace the 208084_110 in the file. I would have a list of text that I want to replace with, for example, 208064_010, 208054_020, 208075_030 etc etc, and after it does the find and replace generate a new csv file named after the text, ex. [url removed, login to view] [url removed, login to view] [url removed, login to view]
It would also be helpful if I could paste in the new list of text replacements because I already have them in a spreadsheet format.