topic Re: Deleting trailing Zeroes in QlikView https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55655#M783941 <HTML><HEAD></HEAD><BODY><P>May be just this</P><P></P><P><STRONG>Left(Field, 2) <STRONG>as ReqOutput</STRONG></STRONG></P><P></P><P>or this</P><P></P><P><STRONG>Left(Field, Len(Field)-2) as ReqOutput</STRONG></P></BODY></HTML> Tue, 06 Mar 2018 16:41:06 GMT sunny_talwar 2018-03-06T16:41:06Z Deleting trailing Zeroes https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55654#M783940 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I am importing a data from CSV file and in 1 field it contains additional Zeroes.</P><P>How I can remove the last 2 zeroes from this field.</P><P></P><P>Example:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="20" width="64">Field</TD><TD width="64"></TD><TD width="64">Output required</TD></TR><TR><TD height="20">1M00</TD><TD></TD><TD>1M</TD></TR><TR><TD height="20">1N00</TD><TD></TD><TD>1N</TD></TR><TR><TD height="20">2B00</TD><TD></TD><TD>2B</TD></TR><TR><TD height="20">2G00</TD><TD></TD><TD>2G</TD></TR><TR><TD height="20">2N00</TD><TD></TD><TD>2N</TD></TR><TR><TD height="20">2Q00</TD><TD></TD><TD>2Q</TD></TR><TR><TD align="right" height="20">3000</TD><TD></TD><TD align="right">30</TD></TR><TR><TD height="20">3Y00</TD><TD></TD><TD>3Y</TD></TR><TR><TD height="20">4H00</TD><TD></TD><TD>4H</TD></TR><TR><TD height="20">4X00</TD><TD></TD><TD>4X</TD></TR><TR><TD height="20">5M00</TD><TD></TD><TD>5M</TD></TR><TR><TD height="20">5U00</TD><TD></TD><TD>5U</TD></TR><TR><TD height="20">5X00</TD><TD></TD><TD>5X</TD></TR><TR><TD align="right" height="20">6400</TD><TD></TD><TD align="right">64</TD></TR><TR><TD height="20">6A00</TD><TD></TD><TD>6A</TD></TR><TR><TD height="20">6J00</TD><TD></TD><TD>6J</TD></TR><TR><TD height="20">6U00</TD><TD></TD><TD>6U</TD></TR><TR><TD height="20">7F00</TD><TD></TD><TD>7F</TD></TR><TR><TD height="20">7T00</TD><TD></TD><TD>7T</TD></TR><TR><TD height="20">8A00</TD><TD></TD><TD>8A</TD></TR><TR><TD height="20">8J00</TD><TD></TD><TD>8J</TD></TR><TR><TD height="20">8N00</TD><TD></TD><TD>8N</TD></TR><TR><TD height="20">8W00</TD><TD></TD><TD>8W</TD></TR><TR><TD height="20">9C00</TD><TD></TD><TD>9C</TD></TR><TR><TD height="20">9F00</TD><TD></TD><TD>9F</TD></TR></TBODY></TABLE><P></P><P>Regards</P><P>Abhijit</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55654#M783940 Anonymous 2020-11-25T16:16:04Z Re: Deleting trailing Zeroes https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55655#M783941 <HTML><HEAD></HEAD><BODY><P>May be just this</P><P></P><P><STRONG>Left(Field, 2) <STRONG>as ReqOutput</STRONG></STRONG></P><P></P><P>or this</P><P></P><P><STRONG>Left(Field, Len(Field)-2) as ReqOutput</STRONG></P></BODY></HTML> Tue, 06 Mar 2018 16:41:06 GMT https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55655#M783941 sunny_talwar 2018-03-06T16:41:06Z Re: Deleting trailing Zeroes https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55656#M783942 <HTML><HEAD></HEAD><BODY><P>Try</P><P>left(Field,2) as Field while loading</P></BODY></HTML> Tue, 06 Mar 2018 17:00:02 GMT https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55656#M783942 shiveshsingh 2018-03-06T17:00:02Z Re: Deleting trailing Zeroes https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55657#M783943 <HTML><HEAD></HEAD><BODY><P>May be Like this?</P><P>Load </P><P>Field,</P><P>If(IsNum(Field),Field/100, SubField(Field,'00',1)) as NewField</P><P>Resident YourTable;</P></BODY></HTML> Tue, 06 Mar 2018 19:19:00 GMT https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55657#M783943 sasiparupudi1 2018-03-06T19:19:00Z Re: Deleting trailing Zeroes https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55658#M783944 <HTML><HEAD></HEAD><BODY><P>After posting I followed the same approach.</P><P>Thanks it worked</P></BODY></HTML> Wed, 07 Mar 2018 11:41:00 GMT https://community.qlik.com/t5/QlikView/Deleting-trailing-Zeroes/m-p/55658#M783944 Anonymous 2018-03-07T11:41:00Z