topic Re: Remove leading zero from Text field? in QlikView https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752540#M268167 <HTML><HEAD></HEAD><BODY><P>Thank you so much both! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jan 2015 20:12:57 GMT 2015-01-22T20:12:57Z Remove leading zero from Text field? https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752537#M268164 <HTML><HEAD></HEAD><BODY><P>Hello there!</P><P></P><P>Can anyone tell me how I can remove leading zero's from a Text field?</P><P></P><P>I have a Text column where the data looks like:</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="125" style="border: 1px solid rgb(0, 0, 0); width: 94px; height: 101px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH></TR><TR><TD style="padding: 2px;">Text</TD></TR><TR><TD style="padding: 2px;">ABC</TD></TR><TR><TD style="padding: 2px;">0001</TD></TR><TR><TD style="padding: 2px;">02</TD></TR><TR><TD style="padding: 2px;">TR01</TD></TR></TBODY></TABLE><P></P><P>I would like a function that picks up the leading zero values in the above column and remove it.</P><P></P><P>How can we do that please? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jan 2015 19:53:34 GMT https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752537#M268164 2015-01-22T19:53:34Z Re: Remove leading zero from Text field? https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752538#M268165 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>Try something like this:</P><P></P><P></P><P>Table1:</P><P>LOAD IF(IsNum(Header1), NUM(NUM#(Header1)), Header1) as Header1;</P><P>LOAD * Inline</P><P>[</P><P>&nbsp; Header1</P><P>&nbsp; Text</P><P>&nbsp; ABC</P><P>&nbsp; 0001</P><P>&nbsp; 02</P><P>&nbsp; TR01</P><P>];</P><P></P><P></P><P></P><P></P><P></P><P></P><P>Kind regards, </P><P>Ernesto.</P></BODY></HTML> Thu, 22 Jan 2015 20:02:05 GMT https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752538#M268165 consenit 2015-01-22T20:02:05Z Re: Remove leading zero from Text field? https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752539#M268166 <HTML><HEAD></HEAD><BODY><P>if(isnum(Field),Text(num(Field)),Field) as Field</P></BODY></HTML> Thu, 22 Jan 2015 20:02:41 GMT https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752539#M268166 jonasheisterkam 2015-01-22T20:02:41Z Re: Remove leading zero from Text field? https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752540#M268167 <HTML><HEAD></HEAD><BODY><P>Thank you so much both! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jan 2015 20:12:57 GMT https://community.qlik.com/t5/QlikView/Remove-leading-zero-from-Text-field/m-p/752540#M268167 2015-01-22T20:12:57Z