After my measurements I end up with a row of failed and passed tests (
x = failed,
o = passed).
This row starts with
o and changes one time.
Example A) xxxoo Example B) ooox Example C) ooxxxxx
I am now searching for a function that gives me the second part of the string where all letters are the same up to a maximum of 4 letters. So the results will be:
A) oo B) x C) xxxx
I know that I can get the last digits with
RIGHT() but I don't know how to check for the length of the "only
x" or "only
o" part at the end.