Get Nth Item from the result of Split function

[pNabin]

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

[CarlosFigueira · Accepted 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!