I have a directory with hundreds of CSV files in it. Many of the files have synonyms for words that I no longer want. I want to replace all of the synonyms with approved words. For example some CSVs have synonyms like vial
jug
canteen
urn
etc and I want to replace all of those with the word bottle
. How would I do this? I know I can use glob
to go through all of the files and I found http://stackoverflow.com/questions/17536138/replace-multiple-strings-in-csv-file?lq=1 but that does not really do what I need.
Does anyone have any ideas?