I have a string that I need to parse. The text will vary but the format always the same.
Example Text: Hello5-E-100
I need this parsed into two variables.
First being Hello5-E and the second simply 100
You said the format will always be the same.
Does that mean it will always be 6 a/n chars, a dash, a char, another dash, 3 numbers?
Or it will always be a string of varying length containing 2 dashes somewhere?
If the latter, simply using LEFT and RIGHT would suffice. But I suspect that's not the answer or you would have thought of it yourself - so see the other replies.