Not sure how much detail I can give on this request, so just trying to hit my 20 char. :gift:
Would love a find/replace option!
+3Seconding this. Would be nice to find/replace within a single column in particular. Just encountered a need for this, but fortunately my database is small enough right now to do it manually.
Thanks for the feedback, guys! We’ll definitely take this into consideration, as it’s a request we’ve had from a lot of users.
In the meantime, if you have, say, a single line text field which repeats a lot of the same answers over and over again, I would suggest [if appropriate] trying to use a single or multiple select field instead, as it’s much easier to edit the options for the select tokens in the field configuration menu.
Another strategy is sorting by the value you wish to change, and using the fill handle to easily copy the replaced version over a larger range of cells.
Thanks for the feedback, guys! We’ll definitely take this into consideration, as it’s a request we’ve had from a lot of users.
In the meantime, if you have, say, a single line text field which repeats a lot of the same answers over and over again, I would suggest [if appropriate] trying to use a single or multiple select field instead, as it’s much easier to edit the options for the select tokens in the field configuration menu.
Another strategy is sorting by the value you wish to change, and using the fill handle to easily copy the replaced version over a larger range of cells.
Just thougth the option to copy and paste in Excel, replace text, and copy back to Airtable.
+2+1. The workaround @Katherine_Duh recommends is great if you’re trying to make all cells the same value, but in our case we need to remove a particular string of text from a column of text fields that have otherwise unique values:
We have a link column with hyperlinks for a content inventory. The ones that go to PDFs were prepended by a Chrome extension, so they all begin with chrome-extension://oemmndcbldboiebfnladdacbdfmadadm/ and then the actual URL. So now we have to manually edit all those fields.
What I ended up doing was copy pasting those cells into Google Sheets, find and replacing, and pasting back.
+27I’m reviving this request because its a must! I have an imported table that repeats this “�” character a lot, randomly in many columns. It would be nice to clean up my data within Airtable without having to export to Excel and then back into AT.
The only workaround I can think of is using a formula field to one by one use a SUBSTITUTE() formula for each column. I have upwards of 20 columns so I think adding this as a feature (maybe even a Block) would be beneficial.
I need to use the workaround to copy into google sheets and back to accomplish this, but I can’t imagine that’s what the Airtable team wants. Would love to just find and replace with the search function.
+7I am adding my own request to this list. Not sure why it is still missing, this is an essential database feature.
I am here to share one incident regarding this specific topic of find and replace option. Few days back when I am working with my Excel worksheet all of a sudden its find and replace option stopped working. I don’t have any idea why I am getting such issue and how to fix it. When I searched for the solution, I got this helpful post, it worked to resolve Excel find and replace not working issue.
So, anyone also dealing with the same situation then, check out this tutorial.
Thanks for the feedback, guys! We’ll definitely take this into consideration, as it’s a request we’ve had from a lot of users.
In the meantime, if you have, say, a single line text field which repeats a lot of the same answers over and over again, I would suggest [if appropriate] trying to use a single or multiple select field instead, as it’s much easier to edit the options for the select tokens in the field configuration menu.
Another strategy is sorting by the value you wish to change, and using the fill handle to easily copy the replaced version over a larger range of cells.
Good idea, but it wouldn’t work in this case: replacing a comma(,) with a point(.) for all records for example!
Coming late to the conversation, has this feature been released yet? If not, why? It is much needed!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.