- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 05, 2023 09:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2023 12:07 AM
Just checking, but have you tried the "Find and replace" script?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2023 01:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2023 02:34 AM
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
