topic Re: Insert Data in App Development https://community.qlik.com/t5/App-Development/Insert-Data/m-p/118645#M8282 <HTML><HEAD></HEAD><BODY><P>Hi Surawut,</P><P></P><P>if you handle the field as text you can do it, if the position is allways the same, then try this:</P><P>=num(left(number1,3)&amp;'18'&amp;right(number1,7))</P><P></P><P>G.</P></BODY></HTML> Wed, 12 Sep 2018 16:54:47 GMT undergrinder 2018-09-12T16:54:47Z Insert Data https://community.qlik.com/t5/App-Development/Insert-Data/m-p/118644#M8281 <HTML><HEAD></HEAD><BODY><P>I want to put number 18 between 602 and 0100380.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">number 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">number 2</TH></TR><TR><TD style="padding: 2px; text-align: center;"><SPAN style="vertical-align: inherit;">6020100380</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="vertical-align: inherit;">602180100380</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Note: This post was edited by a Community Moderator to include English translation as a courtesy.</P></BODY></HTML> Wed, 12 Sep 2018 01:44:48 GMT https://community.qlik.com/t5/App-Development/Insert-Data/m-p/118644#M8281 Anonymous 2018-09-12T01:44:48Z Re: Insert Data https://community.qlik.com/t5/App-Development/Insert-Data/m-p/118645#M8282 <HTML><HEAD></HEAD><BODY><P>Hi Surawut,</P><P></P><P>if you handle the field as text you can do it, if the position is allways the same, then try this:</P><P>=num(left(number1,3)&amp;'18'&amp;right(number1,7))</P><P></P><P>G.</P></BODY></HTML> Wed, 12 Sep 2018 16:54:47 GMT https://community.qlik.com/t5/App-Development/Insert-Data/m-p/118645#M8282 undergrinder 2018-09-12T16:54:47Z