Check in Manuals . 1. Right-click in the Files folder, and New a Array file. 2. You can fill in the cell with content, or copy and paste cell contents from an e...
Do you mean, containing multiple groups of text in the same cell? For example, use the "|" symbol to split:
Apple|Banana
Then when you use Array.At() to get the text, you can continue to use System expressions tokenAt() to extract the words.
tokenat("Apple|Banana", 0, "|") returns Apple.
-------------------------
If you are not sure how many group there are,
Apple|Banana|Carrot|Durian
you can also use tokencount to get the words count, Then iterate it with System conditions For or Repeat , and then use loopindex expression to get the index.
text = Array.At() Repeat tokencount(text, "|") times word = trim(tokenat(text, loopindex, "|"))
text = Array.At()
Repeat tokencount(text, "|") times
word = trim(tokenat(text, loopindex, "|"))
As an additional, you can also use trim(), to remove the space between them.
Apple | Banana
So they might be
text = Array.At() word = trim(tokenat(text, 0, "|"))
word = trim(tokenat(text, 0, "|"))