How do I get only letters from a string

Hello,

I have strings like this eg.

123456-NAME-XXX

what i need is to extract only letters (name) between "-" delimiters

any tips?

i can even set string as this:

123456-NAME

or this

123456NAME

and remove only numbers?

Tnx!

Taking the 123456-Name example, the 'Name' can be extracted using "tokenat('123456-Name', 1, '-')"

briggybros

thanks,

but will this work becouse numbers and letters are random, not allways the same.

i feel it must be with some range from 0-9... but cant find range expression... no?

if the numbers and letters are always separated by a '-', then that expression will always get the second part.

briggybros

thanks!

iw made it!!!!