This would have been a lot easier if not for certain situations.
Sample data:
KENP989SD
KENP913E
KENPX189R
KENP913
What regular expression can I use to remove all characters from the string starting at the first non-alpha character? Basically, I want to find the first non-alpha character and chop everything off after that regardless of char type.
After regex is applied, these data should be:
KENP
KENP
KENPX
KENP