How do I extract a substring from the middle of a larger string? For example, if I have a string (one of many in a list with different sizes):
WXYZ 100 THIS IS THE STRING I WANT 56.78 0905
and I would like to extract "THIS IS THE STRING I WANT".
I can't use substr() as the offsets are not always the same (for example, the first 2 words could be "WXY 10"). I tried substr() with a combination of index(), but couldn't figure out how to do a alpha or numeric wildcard for the search substring. The first two 'words' and the last 2 'words' always have the same characteristics (i.e. all letters or all digits).