Building a script for a mass Find & Replace Automation

[tomsavage]

Hi, 

I am looking to build a script that will allow me to run a large find and replace on Airtable en masse so I do not need to do each one individually. I have a list of around 137 words, they are sectors, that I would like to replace with broader sector categories or something along those lines.

For example, Film > Entertainment or Media & Healthcare Products > Healthcare. The sector on the left is what I would like to find and the category on the left is what I would like to replace. 

Does anyone have a script like this to hand where i can replace the find and replace words, or please could someone help me in creating this code. 

Thanks

[TheTimeSavingCo]

Just checking, but have you tried the "Find and replace" script?

[tomsavage]

Yes, I did look at this extension and this is how I originally started doing it. Thanks for highlighting it. However, I have circa 100 words to find and replace, so I have to run the script over 100 times. I am wondering if there is a way to upload a table or list of the circa 100 words I am looking to find & replace. The aim is to only need to run the script once, rather than individually for each word.

[TheTimeSavingCo]

Ah, I'm not aware of anything pre-built that's like that I'm afraid.  Creating a wrapper around that "Find and replace" script to handle a list of words you gave it would probably take an hour or so I reckon