topic Re: sub string in QlikView https://community.qlik.com/t5/QlikView/sub-string/m-p/961952#M960477 <HTML><HEAD></HEAD><BODY><P>SubField([Your Field Name], '¦', 2)</P></BODY></HTML> Mon, 26 Oct 2015 09:30:30 GMT morganaaron 2015-10-26T09:30:30Z sub string https://community.qlik.com/t5/QlikView/sub-string/m-p/961951#M960476 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>My output data below looks like this . In the qlikview script I am concatenating 2 columns .so I get below result</P><P></P><P>954379543867 ¦&nbsp; decode</P><P>38473843 ¦ capcitors</P><P>985764543988590 ¦ cables</P><P></P><P>using the expression can I take the values after the symbol&nbsp; '¦'</P></BODY></HTML> Mon, 26 Oct 2015 09:26:37 GMT https://community.qlik.com/t5/QlikView/sub-string/m-p/961951#M960476 raadwiptec 2015-10-26T09:26:37Z Re: sub string https://community.qlik.com/t5/QlikView/sub-string/m-p/961952#M960477 <HTML><HEAD></HEAD><BODY><P>SubField([Your Field Name], '¦', 2)</P></BODY></HTML> Mon, 26 Oct 2015 09:30:30 GMT https://community.qlik.com/t5/QlikView/sub-string/m-p/961952#M960477 morganaaron 2015-10-26T09:30:30Z Re: sub string https://community.qlik.com/t5/QlikView/sub-string/m-p/961953#M960478 <HTML><HEAD></HEAD><BODY><P>Trim(SubField([Your Field Name], '¦', 2))</P></BODY></HTML> Mon, 26 Oct 2015 10:02:03 GMT https://community.qlik.com/t5/QlikView/sub-string/m-p/961953#M960478 sasiparupudi1 2015-10-26T10:02:03Z Re: sub string https://community.qlik.com/t5/QlikView/sub-string/m-p/961954#M960479 <HTML><HEAD></HEAD><BODY><P>For the first field:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Trim(SubField([Your Field Name], '¦', 1)) as First</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">And for the second:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Trim(SubField([Your Field Name], '¦', 2)) as Second</SPAN></P></BODY></HTML> Mon, 26 Oct 2015 10:17:13 GMT https://community.qlik.com/t5/QlikView/sub-string/m-p/961954#M960479 ecolomer 2015-10-26T10:17:13Z