topic Function LPad or RPad in QlikView https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524300#M1143445 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have to use Lpad function beacause i must convert a number with two characters (ex. 9 to 09).</P><P>I did not found it? Can Anyone help me, please?</P><P>Francesco</P></BODY></HTML> Fri, 23 Aug 2013 09:19:09 GMT 2013-08-23T09:19:09Z Function LPad or RPad https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524300#M1143445 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have to use Lpad function beacause i must convert a number with two characters (ex. 9 to 09).</P><P>I did not found it? Can Anyone help me, please?</P><P>Francesco</P></BODY></HTML> Fri, 23 Aug 2013 09:19:09 GMT https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524300#M1143445 2013-08-23T09:19:09Z Re: Function LPad or RPad https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524301#M1143446 <HTML><HEAD></HEAD><BODY><P>Hi Francesco,</P><P></P><P>Please try this:</P><P></P><P>=num(9,'00')</P><P></P><P>regards,</P><P></P><P>Abey</P></BODY></HTML> Fri, 23 Aug 2013 09:32:52 GMT https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524301#M1143446 abeyphilip 2013-08-23T09:32:52Z Re: Function LPad or RPad https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524302#M1143447 <HTML><HEAD></HEAD><BODY><P>if your field is myField and you need a string of 10 characters:</P><P></P><P>repeat('0', 10-len(myField)) &amp; myField</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 23 Aug 2013 09:34:45 GMT https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524302#M1143447 alexandros17 2013-08-23T09:34:45Z Re: Function LPad or RPad https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524303#M1143448 <HTML><HEAD></HEAD><BODY><P>Thank you Alessandro.</P><P>It is a correct solution.</P><P>Francesco</P></BODY></HTML> Fri, 23 Aug 2013 10:20:32 GMT https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524303#M1143448 2013-08-23T10:20:32Z Re: Function LPad or RPad https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524304#M1143449 <HTML><HEAD></HEAD><BODY><P>Can you please mark the answer as correct?</P><P>Thank you</P></BODY></HTML> Fri, 23 Aug 2013 10:28:02 GMT https://community.qlik.com/t5/QlikView/Function-LPad-or-RPad/m-p/524304#M1143449 alexandros17 2013-08-23T10:28:02Z