Suppose I have a field titled NAME1.
Examples of what is in the field appear like this:
Fox Lake 1
WABASCA 166
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:
1
166
196G
90-8
114-17
9X02
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.
أكثر...
Examples of what is in the field appear like this:
Fox Lake 1
WABASCA 166
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:
1
166
196G
90-8
114-17
9X02
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.
أكثر...