When we use the value of the collection variable at Form,
we need to export the item with "get Item from collection" and set it as each individual User define variable.
It is very inefficient and make variable list too long.
If there is a function like getNthItem in form variable, needed effort will be significantly decreased.
Hi Juyoung, are you able to help me understand a couple of user scenarios for this function? We are planning to expand on the collection operations so you rinput will be very helpful. Thanks
Hi,
you can use the "Replace" function with some Regx as following example:
replace([Form].[rsREGX],"^(?:[^,]+,){"+convertToString([Form].[Row]-1)+"}([^,]+).*", "$1")
this code is using a regular expression to extract a specific portion - in your case the Nth-item of a string/Collection based on the provided pattern and replace the entire string with that extracted portion, so basically it extract and Get the Nth item from collection.
Hope that help,
Thanks,Majid