Hi all.
I was wondering if someone might be able to help.
I have a list of product ID’s, some of which end in codes which I need to remove. These codes can will be a mix of letters and numbers (but it will always be a letter and then any numbers).
What I need to do is strip out the last part of the code, starting from when there is a letter after a set of numbers (i.e. the product codes can sometimes start with a letter, then be followed by a series of numbers, and then the additional code would be a letter and possibly some numbers).
e.g. if you had a code of 123RS, I need just 123. If I had a code of T123R2, I need just T123. If I had the code of ER123QZ I would need just ER123 etc.
I’ve included an example of the types of code formats I have and the output I’m looking to achieve, but I’m not sure how I go about this and would much welcome any ideas!
Many thanks
Bookmarks