Hi,
I have to get the 5th & 6th item splitted by '/' in an URL (like : "https://hello.com/sites/customer/portal/details") which is customer & portal.
I have used the split function and stored it in collection with one Column (Result).
ClearCollect(colSplittedURL,Split(TextInputURL.Text,"/"))
How can I get Nth (5th & 6th) item from collection colSplittedURL?
I know First(colSplittedURL) gives the first item and Last(colSplittedURL) gives the last item of the collection but I don't know how to get soemthing in the middle.
Thanks,
Nabin
Solved! Go to Solution.
You can use a combination of the FirstN and Last functions to access an item at a specific index. To get the 5th element from your collection you'd use
Last(FirstN(colSplittedUrl, 5))
And similarly for the 6th element:
Last(FirstN(colSplittedUrl, 6))
Hope this helps!
You can use a combination of the FirstN and Last functions to access an item at a specific index. To get the 5th element from your collection you'd use
Last(FirstN(colSplittedUrl, 5))
And similarly for the 6th element:
Last(FirstN(colSplittedUrl, 6))
Hope this helps!
User | Count |
---|---|
142 | |
142 | |
78 | |
75 | |
72 |
User | Count |
---|---|
228 | |
143 | |
78 | |
62 | |
58 |