I need to parse a text field in a query. The values I need are always after these values:
Then I need to stop the parse at either the end of the text value totally or at the next "-"
6061-T6-RD-0.567-.010 - I need the 0.567 only
4340-RD-0.4375 - I need the 0.4375 only
They don't always have the same amount of characters though as you can see above in my examples. So if there is a "-" after the value I need then it should stop the parsing at the "-". If there is no "-" after it then I just need the balance of the text values which will always end as shown above. BUT the values won't always be the same length in characters. I hope this explains it clearly enough.