Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Creating multiple select field from semicolon-separated text

Topic Labels: Base design
Solved
Jump to Solution
1756 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! I’m new to AirTable and I’m not very advanced with using functions, but I think I will need to use at least a few to do what I’m trying to do. I currently have a column of what are essentially tags for a given gene’s function, and I’d like to convert them to tags in Airtable by making them each options in a multiple-select field. Is there a way to easily use the semicolons in the text as separators/delimiters to automatically generate the selections and convert the entries as they are to multiple select smoothly?

image

Thanks in advance!

1 Solution

Accepted Solutions

You could do this easily with commas as the separators but not semicolons. One method would be to import your data, then duplicate the {Gene ontology} field and convert the duplicated field to a Formula field and give it this formula: SUBSTITUTE({Gene ontology},"; ",","). This will convert the semicolons to commas. Then you can convert the same field to a Multiple Select Field.

See Solution in Thread

2 Replies 2

You could do this easily with commas as the separators but not semicolons. One method would be to import your data, then duplicate the {Gene ontology} field and convert the duplicated field to a Formula field and give it this formula: SUBSTITUTE({Gene ontology},"; ",","). This will convert the semicolons to commas. Then you can convert the same field to a Multiple Select Field.

Perfect, thanks so much!