Logic needed to seperate text characters from a alphanumeric value

[#1]

Dear all,

I have a field/column consists of User Names with the addition of numericals.

Ex: "abc12", "12abcd","aavv"

Note: Text is variable length and can present anywhere in the field as shown in example.

Now i need to seperate text only.

How i can achieve this?

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

purgechar(MyText, '0123456789')

[tresesco]

Try Keepchar()/purgechar()

[#4]

Thankyou