I have text strings from each of which I need to extract a specific character string. The character string I need to extract always has the same number of characters however the original text strings are not all the same length. An example text string is below. The segment - Serial number: - is always the same. The string I need to extract is the 5 digits following Serial number: There is always a ; following the 5 digit serial number which I do not wish to include.
Equipment QD5fj425; Serial number: 93222; Firmware: V 4.47 - 11/08 AV; QD5 Version: V 6.01
Any help is appreciated. Thank you.