Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Separate String of Values by Comma

Topic Labels: Data Formulas
Solved
Jump to Solution
734 1
cancel
Showing results for 
Search instead for 
Did you mean: 
alyssarados
4 - Data Explorer
4 - Data Explorer

I am trying to separate the values in the "ADKAR numerical value" column so that the first number (2) is inputted into the "Awareness value" column. Then so on where I input the next number after the comma into another column, etc.

Any help is greatly appreciated! 🙂 

 

Screenshot 2024-03-06 at 11.18.06 AM.png

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

If it is a Lookup field, the Arrayslice function could be used.

The following formula extracts the first one

ARRAYSLICE({Lookup field)},1,1)

Using Array Functions In Airtable | Airtable Support

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

If it is a Lookup field, the Arrayslice function could be used.

The following formula extracts the first one

ARRAYSLICE({Lookup field)},1,1)

Using Array Functions In Airtable | Airtable Support