I have any number of different strings that contain any length of characters. i want to go through and shorten them to 12 digits long (that is the easy part) however if after being shortend any of the items contain numbers on the end of them like "HALLMAKR 12'
I need it to remove the numbers off of the string and the extra space at the end. and make it "HALLMAKR".
This is ok though: "MAGIC KING" (spaces are fine unless they are before numbers at the end)
Thanks for the help