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).
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.
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
And similarly for the 6th element:
Hope this helps!
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand