Can you tell me the formula to use in order to extract the characters found in the SECOND TO THE LAST number in this type of string?
In this above example I need to extract the "98" and the "2" in the above 2 examples. It would always be the number (1-3 digits) immediately BEFORE the last "_"
What I will more than likely needing to do is LINK one table that contains this NUMBER to another table that has the number is a more normal format of 98.
I'm needing to LINK TABLE 1 (CODING "Extract" number ie. 98) with TABLE 2 BATCH number field.
How can I first of all extract the number, then if possible use the extract to LINK the two tables???