I have a unique problem - I have a requirement to retrieve a substring which appears between the fourth and fifth underscores in a string. The parent string varies in length, so I actually have to do a bunch of charindexes on the underscores to get what I need. I'm having a hell of a time trying to do this.
Following is an example of the string -
I need to retreive the numbers between the fourth and fifth underscores.
Here is another example string -
The strings can vary in length which is making this more difficult.
Can anyone help?