I am trying to parse data between certain characters but not sure how to go about this in a SQL view. The values I am trying to parse out are all numeric. They are wrapped in between a dash on each side. But there are also other numeric values in the data that are wrapped in between dashes so I want to make sure I grab the right section. The section I am looking to grab has 2 letters and a dash before it and then a dash after it. There are also other numeric values after the trailing dash but I don't want that section. Here are a few examples:
From this example I want to grab the 0.2487 440FSE-RD-0.2487-.0004X36
From this example I want to grab the 0.065 TI-GR2-TU-0.065-.0020
The 2 letters before the first dash aren't always the same but it will always be just 2 letters. Then they're followed by a dash. Then the numeric portion that I want follows that dash. And then it ends with another dash and then either more numeric characters or letters after that trailing dash. So the beginning will always start with 2 letters and then a dash. And the ending will always end with a dash. So how can I write this in my SQL view to grab this section?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.