topic Script PRob in QlikView https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865104#M1017788 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>I ahve id as:&nbsp; ABC\gnikhil</P><P>In my script, i want Id as : gnikhil only. How to acheive this?</P><P></P><P>thanks</P></BODY></HTML> Tue, 07 Apr 2015 09:11:43 GMT nikhilgarg 2015-04-07T09:11:43Z Script PRob https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865104#M1017788 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>I ahve id as:&nbsp; ABC\gnikhil</P><P>In my script, i want Id as : gnikhil only. How to acheive this?</P><P></P><P>thanks</P></BODY></HTML> Tue, 07 Apr 2015 09:11:43 GMT https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865104#M1017788 nikhilgarg 2015-04-07T09:11:43Z Re: Script PRob https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865105#M1017789 <HTML><HEAD></HEAD><BODY><P>SUBFIELD(MyField, '\', 2)</P><P></P><P>Peter</P></BODY></HTML> Tue, 07 Apr 2015 09:14:55 GMT https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865105#M1017789 prieper 2015-04-07T09:14:55Z Re: Script PRob https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865106#M1017790 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>Subfield([FIELD],'\',2)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as "FIELD"</P></BODY></HTML> Tue, 07 Apr 2015 09:16:29 GMT https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865106#M1017790 fvelascog72 2015-04-07T09:16:29Z Re: Script PRob https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865107#M1017791 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Use SubField function in script</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">SubField</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">&lt;your field&gt;</SPAN><SPAN style="font-size: 10pt;">,'\',2) as &lt;your field&gt;</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;"><SPAN lang="en"><SPAN class="hps">the third parameter</SPAN> <SPAN class="hps">indicates the column</SPAN> <SPAN class="hps">that</SPAN> <SPAN class="hps">interests you</SPAN> <SPAN class="hps">after</SPAN> <SPAN class="hps">the split,</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">the count</SPAN> <SPAN class="hps">starts at 1</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN><SPAN style="font-size: 10pt;"> </SPAN></P><P></P></BODY></HTML> Tue, 07 Apr 2015 09:19:54 GMT https://community.qlik.com/t5/QlikView/Script-PRob/m-p/865107#M1017791 2015-04-07T09:19:54Z