Find nth item in string list

nickedw0 — Thu, 30 Nov 2017 19:36:24 GMT

I need to pull a preselected item from a list of items (array list) in script:

list is a string of names: 'James','John','Jill'

given a selector of 2, how can I get the second item in list, namely 'John'?

Thanks

Re: Find nth item in string list

Anonymous — Thu, 30 Nov 2017 19:42:53 GMT

use subfield()

--> 3 parameter variant

for example:

subfield(YOURFIELD,',',2)