Extract characters from a field
I am trying to figure out how to extract a string of characters from a field. They all start with 09 and are 10 characters long. They could be anywhere in the field beginning middle or end.
example of data in the field
|
CUT 2 (09GN20T-01) LEADS |
(09BN22R-01) CUT 3.5" |
CUT 2 (09GN20T-01) LEADS |
09BN22R-01 CUT 3.5" WITH |
CUT 09BN22R-01 1.50" LONG 1 |
|
So the result I am looking for is
DESC |
09GN20T-01 |
09BN22R-01 |
09GN20T-01 |
09BN22R-01 |
09BN22R-01 |
|
Any help with this would be much appreciated!