Transformation of columns data

[Seemakurthi_Jaswanth]

I want to transform my data in a QlikSense script where the data in every column is similar to "��345" I want to remove this �� data and transform the data into meaningful data in each column.

How can I transform all the columns at once from which I can remove the �� data from all the columns at once?

[rwunderlich]

For each column use the keepchar() function. 

keepchar(colx, '0123456789') as colx

Do you have a concern that there are many columns to repeat this pattern for?

-Rob