Parsing splitted text

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.

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.

1 Like

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).

1 Like