I use the following string to capture/record notes in a field:
String: AA-AnyTwoLettersHere(ddShortMonthYYYY)
Example: AA-BB(05May2012)
I want to extract
a) the two letters following "AA-"
b) the date in brackets.
Problem is the field may also contain similar variations of the string, such as:
AA-BB(05May2012_SomeTextHere) - Don't want to extract the text following the date
AA-BB/05May2012 - Don't want to extract anything here because it follows a different convention
To make it more complicated, if the string is found more than once in the field I want to only extract the two bits of info from the LAST instance of it in the field.
Does anyone think they can help me?