Araay gives unpredicted results

[Hein]

Hi all

The array I have created to find characters in a cell gives unpredictable results:

Please Login or Register  to view this content.

The idea is that in given strings I have to determine the positions of different characters
e.g. a string can be 1.11.11 of 1-1-11 or 1111/3333/444444 etc

If all dividing characters (as given in the array) are the same the formula works fine

The problems start when 2 different characters are used in the same string: eg 12.3455-67

Is there a way to correct this?
For clearity I have added a demofile

Thanks in advance
Hein

[romperstomper]

You could use the same function for both and just specify which match you want:

Please Login or Register  to view this content.

Called with:
=GetCharacter(E4,1)
or
=GetCharacter(E4,2)

As in your examples, I assumed that if you specify a match number that is greater than the total number of matches, it just returns the last position. (e.g. if you specify 2 and there's only 1 special character, it returns the position of the last one)

Also, I think that E16 should be 7 not 8 dues to the space between - and /

[Hein]

Hi Rory,

Thank you for your valuable contribution, much appreciated!

Your code works perfectly, all combinations I have tried give the correct results.
About your last comment: I think that you are right about it, the space is 1 of the character, I made a mistake, sorry.

I will implement your code and as far as I can see I will use the strTime as the cell vaue, and "hard -code" the 1 and 2 for the 1st and 2nd character

Once again: thanks
Hein

[romperstomper]

Glad to help. Please remember to mark the thread Solved using the Thread Tools link at the top of the page.

[Hein]

I will do that
I have also added your rep!

[romperstomper]

Thank you.