I have a string and I want to look for a reference in a specific format which could be anywhere in the string. This reference is random, but will always be in the same format.
The format looks like this. N######NN##
The string would look like this.
Dim MyString as String = "this is my string Z123456TW00 and I need to obtain the reference"
My aim is to take this value and compare it to a reference in my database.
Any ideas how I can obtain anything in the format above regardless of the numbers or letters?