access 2010
I need to parse the data for the 7digit numbers within a string.
The digits will always be 7 in length. Some data in () are not numbers. Some do not have ending ).
example data:
Park smith (sam)
Park miller 23
WT 456 Bisa
Keepan (2345678)
Ington (3456789)
Untom (3245678
I need the 7 digits only an to be formatted as numeric.
2345678
3456789
I am the worst at parsing, need your expertise.
I need to parse the data for the 7digit numbers within a string.
The digits will always be 7 in length. Some data in () are not numbers. Some do not have ending ).
example data:
Park smith (sam)
Park miller 23
WT 456 Bisa
Keepan (2345678)
Ington (3456789)
Untom (3245678
I need the 7 digits only an to be formatted as numeric.
2345678
3456789
I am the worst at parsing, need your expertise.