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...
Thank you very much
i have a question:
I have an array that contains words, which are divided into two groups: family and family members. How can I extract the words from the first group only then from the second only ?
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, "|"))