extract a text from a string

[kavieweg]

Hi togehter,

i have a set of IDs and would like to extract the text:

ID:

ABCD123455677 --> should be ABCD

DEL18383939393930303 --> Should be DEL

The lenght of the ID and containing variouses. 

[y_grynechko · Accepted solution]

Hey,

one of a few options: 

I

[kavieweg]

Thxs a lot. This solved my problem perfectly 🙂