Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Only retrieve text data from a field and remove all #

Hello,

How can I remove in a script, any numbers from a text field, regardless if the numbers are in the beginning, middle, or end of the text string?

An examble would be

123abc789 = abc

5dfg7246 = dfg

athu8979761 = athu  

Thanks!

Jen

1 Solution

Accepted Solutions
Gysbert_Wassenaar

This should do the trick:  purgechar(MyField, '0123456789')


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

This should do the trick:  purgechar(MyField, '0123456789')


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thank you!