How would I return an IndexOf trying to match only the first value per cell?
I am hoping to organize like this:
The first number is the Act, second number the Scene...
I've been trying to use Left(,) but I can't get it to work.
To pull Act 2 I've tried:
doesn't seem right.
also doesn't seem to work.
I know I could bubble-process this but it seems there should be an easier way to write this.
Currently I am doing this:
If: left(array.At(array.CurX), 1)) = 1 then StopLoop and DoThis
If: left(array.At(array.CurX), 1)) = 2 then StopLoop and DoThis
etc, etc... Maybe this is the best way to do this? Except that its not really working either. I am getting the last value that matches not the first...