https://community.qlik.com/t5/App-Development/Transformation-of-columns-data/m-p/2141316#M92820 <P>For each column use the keepchar() function.&nbsp;</P> <P>keepchar(colx, '0123456789') as colx</P> <P>Do you have a concern that there are many columns to repeat this pattern for?</P> <P>-Rob</P> Sun, 26 Nov 2023 19:08:40 GMT rwunderlich 2023-11-26T19:08:40Z https://community.qlik.com/t5/App-Development/Transformation-of-columns-data/m-p/2141239#M92810 <P>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.</P> <P>How can I transform all the columns at once from which I can remove the �� data from all the columns at once?</P> Fri, 15 Nov 2024 21:13:51 GMT https://community.qlik.com/t5/App-Development/Transformation-of-columns-data/m-p/2141239#M92810 Seemakurthi_Jaswanth 2024-11-15T21:13:51Z https://community.qlik.com/t5/App-Development/Transformation-of-columns-data/m-p/2141316#M92820 <P>For each column use the keepchar() function.&nbsp;</P> <P>keepchar(colx, '0123456789') as colx</P> <P>Do you have a concern that there are many columns to repeat this pattern for?</P> <P>-Rob</P> Sun, 26 Nov 2023 19:08:40 GMT https://community.qlik.com/t5/App-Development/Transformation-of-columns-data/m-p/2141316#M92820 rwunderlich 2023-11-26T19:08:40Z