Hi! This may be a totally obvious thing but I can't seem to figure it out.
I have an array filled with object names:
0 "Alpha01"
1 "Alpha02"
2 "Beta01"
3 "Beta02"
4 "Beta03"
5 "Delta01"
6 "Delta02"
7 "Delta03"
8 "Delta04"
9 "Epsilon01"
I would like to scan each cell for first letter and return the cell value of the first cell to contain that value.
Looking for "A" would return 0.
Looking for "D" would return 5.
Bonus: Looking for "C" would return 5 or the next closest letter in line.
Basically I am trying to create an alphabet index to jump around the long list in my array to make access quicker...
I think I am just lacking a way to look at only the first letter of each cell and not the whole cell itself.
I will try and make a simpler capx to post... this is one small part of a much larger project, I should have done a prototype in a standalone capx first!
Thanks!