Hi Coleen,
Are you doing this import in from an Excel spreadsheet and that spreadsheet has the lists of options in cells as Option 1, Option 2, Options 3? In addition to Marks suggestion on how to change it in Quick Base you can also use the search and replace in Excel on the field that replace all of the commas in those cells with semi-colons before you do the import. Then you could import that data directly into a Multi-select Text field right from your import. For importing or exporting Multi-select Text fields Quick Base uses semi-colons to divide each choice in the Multi-select Text field.
To use the Find and Replace in excel you would highlight the column with the list of options you want to search and replace in and then either hit Control+F or Use the search box in the upper right hand corner and then you select the little Magnifying glass and select Replace. From within that you can designate a character you want to use the replace what you are searching for. In this instance trading a comma for a semi-colon. So long as you specifically have the column you want to change highlighted it will stay focused on that column. Then when you do your import into Quick Base you can go right into that Multi select text field and save yourself a step in Quick Base.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Original Message:
Sent: 10-17-2019 18:02
From: Coleen Schmitt
Subject: Parsing Text field into Multi Select Text Field Options
Hi,
I'm doing a bulk data upload into a text field and I'm wondering if theres a way that I can take the items listed in regular text field (separated by comma) and transfer them into the options of a Multi Select Text field. Would need to look something like this:
Text Field:
"Option 1, Option 2, Option 3"
Goes into:
Multi Select Text Field:
Option 1
Option 2
Option 3
Wondering if there is a formula that could generate the multi select list or if this is not something thats just not possible to do.
Thanks!
------------------------------
Coleen Schmitt
------------------------------