# How to extract entries from a "Split Text" column into 2 new single value columns?

**URL:** https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508
**Category:** Ask for Help
**Created:** [April 12, 2024, 6:30am UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508 "2024-04-12T06:30:17Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Anshuman](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Anshuman](https://community.glideapps.com/u/Anshuman)
#### Post date: [April 12, 2024, 6:30am UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/1 "2024-04-12T06:30:17Z")

</div>

I am capturing multiple user selections into a Text column and then using Split Text column to create multiple comma separated components like in below screen:

 ![Glide table 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/92a300cc731c7eb5aa6cfa75944a7462497c710a.png)

But when I am trying to store these individual components into separate columns, I used single value column but its not working. Please see the screen below and suggest how to rectify this?

 ![Glide table 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d269b5a2fcbcfed5607cd1d6b132ac01b7d8bac1.png)  
 ![Glide table 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e41e8737a6c216cf583bc78d76b790d5d817cce7.png)

My end objective is to store the split text components into separate columns.

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [April 12, 2024, 6:39am UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/2 "2024-04-12T06:39:52Z")

</div>

Have you tried the “single value” column to select the first or last column of your array.

---

<div class="post-metadata">

### Author: ![Anshuman](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Anshuman](https://community.glideapps.com/u/Anshuman)
#### Post date: [April 12, 2024, 6:48am UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/3 "2024-04-12T06:48:25Z")

</div>

Yes, I tried that combination as well but still getting the same result.  
 ![Glide table 4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/239cdf6dce9cb3653a3ad8eac7db8f794b68a478.png)

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [April 12, 2024, 6:53am UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/4 "2024-04-12T06:53:59Z")

</div>

You must go directly to the subprocess1 column, not to the sheet again.

 ![Screenshot 2024-04-12 at 14.06.58](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2286aae6277798485912a78f346edfb0af14bae.jpeg)

---

<div class="post-metadata">

### Author: ![Anshuman](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Anshuman](https://community.glideapps.com/u/Anshuman)
#### Post date: [April 12, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/5 "2024-04-12T16:50:43Z")

</div>

Thank you. It is working now.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [April 19, 2024, 4:51pm UTC](https://community.glideapps.com/t/how-to-extract-entries-from-a-split-text-column-into-2-new-single-value-columns/72508/6 "2024-04-19T16:51:31Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.