Help

Creating multiple select field from semicolon-separated text

Topic Labels: Base design
Solved
Jump to Solution
2615 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sophie_Sanchez
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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!