topic Script in QlikView https://community.qlik.com/t5/QlikView/Script/m-p/368340#M702935 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have excel sheet with&nbsp; 5 columns every column has some text and numbers , i want to remove the text from every column before loading it.</P></BODY></HTML> Thu, 26 Jul 2012 04:11:34 GMT 2012-07-26T04:11:34Z Script https://community.qlik.com/t5/QlikView/Script/m-p/368340#M702935 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have excel sheet with&nbsp; 5 columns every column has some text and numbers , i want to remove the text from every column before loading it.</P></BODY></HTML> Thu, 26 Jul 2012 04:11:34 GMT https://community.qlik.com/t5/QlikView/Script/m-p/368340#M702935 2012-07-26T04:11:34Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/368341#M702936 <HTML><HEAD></HEAD><BODY><P>try this while loading </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>KeepChar</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Fieldname</SPAN><SPAN style="font-size: 8pt;">,'0123456789')&nbsp; as field1</SPAN><P></P><P></P></BODY></HTML> Thu, 26 Jul 2012 05:01:38 GMT https://community.qlik.com/t5/QlikView/Script/m-p/368341#M702936 sivarajs 2012-07-26T05:01:38Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/368342#M702937 <HTML><HEAD></HEAD><BODY><P><STRONG>Re: Script</STRONG></P><P></P><P>Hi Manish try this one at the time of loading.</P><P><SPAN style="color: #000080;">Keepchar</SPAN>(<SPAN style="color: #ff0000;">Fieldname</SPAN>,'0123456789') as <SPAN style="color: #ff0000;">Fieldname</SPAN></P></BODY></HTML> Thu, 26 Jul 2012 07:02:04 GMT https://community.qlik.com/t5/QlikView/Script/m-p/368342#M702937 senpradip007 2012-07-26T07:02:04Z Re: Script https://community.qlik.com/t5/QlikView/Script/m-p/368343#M702938 <HTML><HEAD></HEAD><BODY><P>Or you can use the function: </P><P></P><P>If( IsNum(filedname), fieldname) As fieldname </P><P>or If( IsText(...), ...) As ...</P><P></P><P>Greetings from Munich</P><P></P><P>Martina</P></BODY></HTML> Thu, 26 Jul 2012 13:28:33 GMT https://community.qlik.com/t5/QlikView/Script/m-p/368343#M702938 brenner_martina 2012-07-26T13:28:33Z