I have a table that contains a field for part numbers. It is a text field. But I need to somehow, I suppose via an update query, rename the part numbers.
Here are a few example of the current part number and the expected renamed part number:
N1100-12R05-F N1100-12-F (Note that the R05 has been removed)
N1375-12X75-F N1375-12-F (Note that the X75 has been removed)
N1202-12PTR4-F N1202-12-F (Note that the PTR4 has been removed)
So in essence, the characters following the 2nd digit after the 1st hyphen through the character prior to the 2nd hyphen have to be removed. In some cases this would be 3 characters and in other cases it would be 4 characters.
How can I do this?