Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
8 years ago

How to bulk change one value to another in a single field?

I have a field in a table where I need to bulk change a specific value to be a different value.  The field is populated through a Multi-select Text and we have updated one of the values in the list of...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Try this.  But I have not tested.

Export a dump to excel of the record ID and the multiselect field.  It should come out as a semi colon delimited list, actually a semicolon and a space.

Use Excel's Find and Replace  to find and replace.

Then upload to your table

BUT!  I have not tested this, so on the first upload, just upload 1 record to see that it works!  Then if all is good import the rest.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Great, now I will know that the technique works for the future.  That find a replace in Excel is super powerful as it replaces within strings.