topic Re: Set text string to fixed Length in QlikView https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255290#M461573 <HTML><HEAD></HEAD><BODY><P>Hi maxgro</P><P>thanks you , it is great</P><P>happy new year</P><P>gidon</P></BODY></HTML> Fri, 30 Dec 2016 22:12:08 GMT gidon500 2016-12-30T22:12:08Z Set text string to fixed Length https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255288#M461571 <HTML><HEAD></HEAD><BODY><P>hi guy</P><P>I need to adjust text string to fixed length&nbsp; 10 positions </P><P></P><P>input</P><P></P><P>Field</P><P>X100XC</P><P>X102X</P><P>Y200PRO</P><P></P><P>output :</P><P>FixedField</P><P>0000X100XC</P><P>00000X102X</P><P>000Y200PRO</P><P></P><P>any easy way to do it&nbsp; ? </P><P>thanks</P><P>gidon</P></BODY></HTML> Fri, 30 Dec 2016 21:36:54 GMT https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255288#M461571 gidon500 2016-12-30T21:36:54Z Re: Set text string to fixed Length https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255289#M461572 <HTML><HEAD></HEAD><BODY><P><EM>load</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; Field, </EM></P><P><EM><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; Repeat('0', 10-len(Field)) &amp; Field as NewField </STRONG></EM></P><P><EM>inline [</EM></P><P><EM>Field</EM></P><P><EM>X100XC</EM></P><P><EM>X102X</EM></P><P><EM>Y200PRO</EM></P><P><EM>];</EM></P></BODY></HTML> Fri, 30 Dec 2016 22:05:00 GMT https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255289#M461572 maxgro 2016-12-30T22:05:00Z Re: Set text string to fixed Length https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255290#M461573 <HTML><HEAD></HEAD><BODY><P>Hi maxgro</P><P>thanks you , it is great</P><P>happy new year</P><P>gidon</P></BODY></HTML> Fri, 30 Dec 2016 22:12:08 GMT https://community.qlik.com/t5/QlikView/Set-text-string-to-fixed-Length/m-p/1255290#M461573 gidon500 2016-12-30T22:12:08Z