I have a list of ID numbers, which I want to store as an array i.e. [1,2,9,2,6], and then have a index number which cycles forward and gives me the Nth value (by index).
What’s the best approach for this?
I’m getting stuck at trying to establish the length of the array, using the count token, it’s just not working. I tried splitting the variable into multiple lines instead of being one-line comma delineated, and using the LINES calculation, still nothing. GPT + Grok are taking me down strange rabbit holes, and I’m struggling to find the right documentation on here.
Could someone point me in the right direction please?
thanks so much
p.s. ccstone’s response in this post shows part of what i’m trying to do, but my “key” is a dynamic number which cycles through the length of the array, from 0 to “array.length()”. How can i find out the array length?
@Evan_Mangiamele's method is great if you want to grab the nth element of your array.
If you want to cycle through the array, doing something to each element in turn, you can use the "For Each" Action that splits your text into a Collection of substrings and loops through that Collection -- you can add an incrementing counter if you want one:
Both methods let you set the string to use as the separator -- with the first you would put the string between the token's ] and the closing %, so to get the 2nd element of the variable Local_myArray that contained the text
cat==mySep==dog==mySep==fish
...you'd use
%Variable%Local_myArray[2]==mySep==%
And both methods fail if any of your elements contain the separator, so
1,2,"Hello, Bob!",4,5
will break. That's when you go back to your bracketed array notation and treat it as a JSON array -- note that KM's JSON arrays are also 1-indexed and 0 still gets you the length of the array:
