Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jenstarr
New Contributor III

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

Re: Only retrieve text data from a field and remove all #

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


talk is cheap, supply exceeds demand
2 Replies

Re: Only retrieve text data from a field and remove all #

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


talk is cheap, supply exceeds demand
jenstarr
New Contributor III

Re: Only retrieve text data from a field and remove all #

Thank you!

Community Browser