Skip to main content
Question

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

  • June 14, 2017
  • 0 replies
  • 96 views
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 possible values, so it has left some invalid values.

The old value = "Customer Services"
The new value = "Customer Service"

The field does hold other values due to it being Multi-select text, so some records may have something else like "Staff", "Customer Services", "Finance" - it's not always the only value in the field.

What do I need to do to bulk change the values in these records?
      This topic has been closed for replies.

      • DavidHawe
      • Registered
      • June 14, 2017
      If you want to do all of them, run your "List All" report.  Then at the upper right, below the table ribbon will be the word More with a caret to its right.  Click on the caret and one of the options should be "Search & replace in this report. 

      Choose the field then the from an to fields and click Next.  Then it will tell you how maby records will change and when you click Ok it will change them
      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.
      Terms & ConditionsAccessibility statement