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.

Separating string of text based on commas

Topic Labels: Formulas
905 1
cancel
Showing results for 
Search instead for 
Did you mean: 
cathdres
4 - Data Explorer
4 - Data Explorer

I have a string of text in one column that i'd like to separate into individual columns. For example: 


Row 1: K, 1st, 2nd, 3rd, 4th, 5th, 6th

Row 2: preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th

Row 3: ages 3+, preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th

For my existing Row 1, I want a formula that will return each in its own column:

K

1st

2nd

3rd

4th

5th

6th

As you can see, the length of characters isn't consistent, but the comma consistently separates the fields I want. How can I use the comma to separate out the text? I've found a way to extract the text before the first comma (LEFT({selection 4}, FIND(",", {selection 4}) -1), but can't figure out the rest. Thanks in advance!

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

You can convert your text field into a linked record field, and all of those values will become their own records in another linked table.