topic Re: How to get this data from a string? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456436#M1166527 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just use this expression :</P><P></P><P>=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))</P></BODY></HTML> Mon, 01 Oct 2012 10:16:25 GMT christophebrault 2012-10-01T10:16:25Z How to get this data from a string? https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456435#M1166526 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I was trying to get only the last name and the first name of one employee,</P><P></P><P></P><P>Curtiz, Jinky Lyza,</P><P></P><P>How to get only Curtiz,Jinky.</P><P></P><P>Please help..</P></BODY></HTML> Mon, 01 Oct 2012 09:50:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456435#M1166526 2012-10-01T09:50:14Z Re: How to get this data from a string? https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456436#M1166527 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just use this expression :</P><P></P><P>=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))</P></BODY></HTML> Mon, 01 Oct 2012 10:16:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456436#M1166527 christophebrault 2012-10-01T10:16:25Z Re: How to get this data from a string? https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456437#M1166528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>its not working.</P><P></P><P>I have this fieldname.</P><P></P><P></P><P>Employee Name</P></BODY></HTML> Tue, 02 Oct 2012 01:44:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456437#M1166528 2012-10-02T01:44:39Z Re: How to get this data from a string? https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456438#M1166529 <HTML><HEAD></HEAD><BODY><P>already got the answer. thank you..</P></BODY></HTML> Tue, 02 Oct 2012 02:06:12 GMT https://community.qlik.com/t5/QlikView/How-to-get-this-data-from-a-string/m-p/456438#M1166529 2012-10-02T02:06:12Z