Extract parts of a text field
Posted on 2013-05-13
I have to come up with a way to extract parts of text in a field. Challenge is that it doesn't always follow the same format. I think there are enough similarities that it can be done but it eludes me as to how to figure it out.
Here is an example of the text:
What I need to extract is the amount of weeks directly in front of the "days of the week". Some end in a "w" and some in "wk". I don't want the alpha "w" or "wk" but the 2 digits in front of it. The second part is to extract the dollar value in front of the last "w" for instance 1.99.
Any help would be greatly appreciated.