topic Substring in QlikView https://community.qlik.com/t5/QlikView/Substring/m-p/482265#M1147047 <HTML><HEAD></HEAD><BODY><P>How can I use substring function in edit script in qlikview??</P><P></P><P>Can anyone give a simple example where substring is used and save it as a new variable in edit script of qlikview model???</P></BODY></HTML> Mon, 15 Jul 2013 19:56:48 GMT suvechha_b 2013-07-15T19:56:48Z Substring https://community.qlik.com/t5/QlikView/Substring/m-p/482265#M1147047 <HTML><HEAD></HEAD><BODY><P>How can I use substring function in edit script in qlikview??</P><P></P><P>Can anyone give a simple example where substring is used and save it as a new variable in edit script of qlikview model???</P></BODY></HTML> Mon, 15 Jul 2013 19:56:48 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/482265#M1147047 suvechha_b 2013-07-15T19:56:48Z Re: Substring https://community.qlik.com/t5/QlikView/Substring/m-p/482266#M1147048 <HTML><HEAD></HEAD><BODY><P>sorry, need to be added :</P><P></P><P>use two diifernt field with substring finction and concatenate it to a single variable and den load script...??</P><P></P><P>please show this type of example...</P></BODY></HTML> Mon, 15 Jul 2013 20:01:59 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/482266#M1147048 suvechha_b 2013-07-15T20:01:59Z Re: Substring https://community.qlik.com/t5/QlikView/Substring/m-p/482267#M1147049 <HTML><HEAD></HEAD><BODY><P>Examples:</P><P></P><P>Text1 = QlikView</P><P>Mid(Text1,1,4) = Qlik</P><P>Mid(Text1,5,4) = View</P><P>Mid(Text1,1,4)&amp;Mid(Text1,5,4) = QlikView</P><P></P><P>Load Mid(Text1,1,4)&amp;Mid(Text1,5,4) as AppQV,</P><P>...</P></BODY></HTML> Mon, 15 Jul 2013 21:07:36 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/482267#M1147049 jolivares 2013-07-15T21:07:36Z