topic Re: problem with script in QlikView https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404206#M150383 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="font-size: 10pt;">left(<SPAN style="color: #800000;">YourField</SPAN>,2)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,5),3)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,9),4)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,4) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;"><SPAN style="color: #800000;">YourField</SPAN> </SPAN></SPAN></P></BODY></HTML> Thu, 28 Mar 2013 14:53:31 GMT 2013-03-28T14:53:31Z problem with script https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404204#M150381 <HTML><HEAD></HEAD><BODY><P>I am having a table which consits of data 1010010001000 </P><P>2020020002000</P><P>2002002002000</P><P>3003000300030</P><P></P><P></P><P></P><P>not i have to load them as </P><P>10.100.1000.1000</P><P>20.200.2000.2000</P><P>20.020.2000.2000</P><P>30.030.0030.0030</P><P></P><P>can anyone help</P></BODY></HTML> Thu, 28 Mar 2013 14:37:04 GMT https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404204#M150381 2013-03-28T14:37:04Z Re: problem with script https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404205#M150382 <HTML><HEAD></HEAD><BODY><P>help</P></BODY></HTML> Thu, 28 Mar 2013 14:50:28 GMT https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404205#M150382 2013-03-28T14:50:28Z Re: problem with script https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404206#M150383 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="font-size: 10pt;">left(<SPAN style="color: #800000;">YourField</SPAN>,2)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,5),3)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,9),4)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,4) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;"><SPAN style="color: #800000;">YourField</SPAN> </SPAN></SPAN></P></BODY></HTML> Thu, 28 Mar 2013 14:53:31 GMT https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404206#M150383 2013-03-28T14:53:31Z Re: problem with script https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404207#M150384 <HTML><HEAD></HEAD><BODY><P>11177715424444640444444</P><P>if i wanted to write in this format 11.17.771.54244446.40.444444</P><P>can you help me with this</P></BODY></HTML> Thu, 28 Mar 2013 15:02:18 GMT https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404207#M150384 2013-03-28T15:02:18Z Re: problem with script https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404208#M150385 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,2)&amp;'.'&amp;<SPAN style="color: #0000ff;">right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,4),2)&amp;'.'&amp; <SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,7),3)&amp;'.'&amp;<SPAN style="color: #0000ff;">right</SPAN>(<SPAN style="color: #0000ff;">left</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,15),8)&amp;'.'&amp; <SPAN style="color: #0000ff;">Left</SPAN>(<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,8),2)&amp;'.'&amp;<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">YourField</SPAN>,6) </SPAN></P></BODY></HTML> Thu, 28 Mar 2013 15:57:05 GMT https://community.qlik.com/t5/QlikView/problem-with-script/m-p/404208#M150385 2013-03-28T15:57:05Z