Hello All,
I have a field that lists part numbers like 01-xxx-xxx, 01R-xxx-xxx, 02-xxx-xxx, 02R-xxx-xxx, 03-xxx-xxx and so on. What I need to try and figure out is if there is way to remove the first 3 or 4 characters from each part number if and only if it starts with a 01-, 01R-, 02- or 02R-. Basically I just want to check the field to see if it starts with those characters and if it does remove them so I am only left with the corresponding part number.
01-xxx-xxx would become xxx-xxx and 01R-xxx-xxx would also be changed to xxx-xxx, whereas 03-xxx-xxx would be left alone and remain 03-xxx-xxx. Again I am not even sure if this is can be done in access or not but would love any and all input. Thanks in advance!