extract 3 numbers from a string

G

gerenrich

Joined
Jul 11, 2014
Messages
1
Reaction score
0
I am trying to extract the first instance of 3 numbers from a string using an update query to update another field in the same table(Master Equipment) titled "Code". the field is called "Equipment". the strings vary in length as well as the location of the 3 numbers needed, but I have examples of all possible locations the 3 number series could be located below. As you will notice, some fields do not contain 3 numbers together, for these I don't want to return a value.
07-FLP58351
07-MFDP58201
1PBE97601
1PT91105-2
2WPF/FF438582
A-WR-1
AAV58101-01
AC47201-01
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract 5 digit number from a column 7
Find/Extract number from a string 4
Help!:Extract Text Using Mid Function 2
extract numbers from a string 3
Extract numbers from string 9
Extracting part numbers 2
extract numbers from text string 4
Find Duplicates within a string 3

Top