Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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.
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
8 years agoQrew Captain
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.