Hi everyone,
I'm trying to find a simple solution to pull out data from a field that contains mixed alpha and numeric characters. The pattern I'm looking for would be ####B####B B=blank space.
The data looks like this:
2343 5634 4567 South cord 5 west Looking to get back 2343 5634 4567
234189 43990 4376 3245 Looking to get back 4376 3245
2311 7324 3289982 329887 West Looking to get back 2311 7324
West cord 1212 3432 6723 3982 8234 72345 Looking for 1212 3432 6723 3982 8234
237778 233478 NW Cord bit tax. Looking for N/A
Currently I'm doing a messy way creating separate fields and converting the number to a * then searching for a '**** **** '
But hoping someone has an easier solution