# Parsing splitted text
**URL:** https://community.glideapps.com/t/parsing-splitted-text/86521
**Category:** Ask for Help
**Created:** [February 27, 2026, 6:22pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521 "2026-02-27T18:22:13Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [February 27, 2026, 6:22pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/1 "2026-02-27T18:22:13Z")
Hello Gliders! An example may best describe what I need. In a cell in a glide table I have “001-003-XMB-00034”. I am using SPLIT TEXT. Then I am using SINGLE VALUE to Get First and Get Last. But how do I get the middle data? In SINGLE VALUE I only have the options: first, last, random, from start, from end.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 27, 2026, 6:40pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/2 "2026-02-27T18:40:05Z")
Use From Start and enter the number of the item you want ‘from the start’ of the array. For example, array item 2 is 1 from the start. Basically it’s just a zero based array, so it starts from 0 and counts up.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 27, 2026, 8:02pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/3 "2026-02-27T20:02:24Z")
> [@mbraunperu](#):
>
> 001-003-XMB-00034
From start 0 → 001
From start 1 → 003
From start 2 → XMB
From start 3 → 00034
The 1st element of the array has index 0.
The 2nd element of the array has index 1.
The 3rd element of the array has index 2.
…
The nth element of the array has index (n-1).
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [February 28, 2026, 6:29pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/4 "2026-02-28T18:29:10Z")
Thanks a lot Jeff. That easy huh? Sorry I could not figure it out by myself.
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [February 28, 2026, 6:31pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/5 "2026-02-28T18:31:02Z")
Thanks a lot Nathan!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 7, 2026, 6:31pm UTC](https://community.glideapps.com/t/parsing-splitted-text/86521/6 "2026-03-07T18:31:03Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.