Suppose I have a field titled NAME1.
Examples of what is in the field appear like this:
Fox Lake 1
TSU TUE 196G
YELLOW QUILL I.R. 90-8
POUNDMAKER INDIAN RESERVE NO. 114-17
CROSS LAKE 19X02
BEARDY'S & OKEMASIS I.R. 96 & 97A
How using python or vb script would I extract a string only after the first digit into a new field titled Name_Num?
Basically, the Name_Num field would have to appear like this:
96 & 97A
Mind you, I need the letter attached to the numbers. I can't just extract digits only. But anything before the first number must go. The numbers vary in character length but always appear at the end of my string.
I rarely use python and am not familiar with when something goes into the pre-code block or doesn't.
These are the results after inputting the first reply which looked great in my opinion but didn't work unfortunately.