I need to get the 1st part of a string, the only consistencies would be that the string would start with at least 1 letter. If it contains numbers I just want the part before the 1st number.
eg.
AB1234 // need to return AB
A3A2N123 // need to return A
CB123Z // need to return CB
X32A123 // need to return X
CC892CCX384B // need to return CC
ZB // need to return ZB
Y // need to return ZB
Thanks