Solved: How to get this data from a string? - Qlik Community

Report Inappropriate Content · ‎2012-10-01

Hi,

I was trying to get only the last name and the first name of one employee,

Curtiz, Jinky Lyza,

How to get only Curtiz,Jinky.

Please help..

christophebrault · ‎2012-10-01

Hi,

Just use this expression :

=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

christophebrault · ‎2012-10-01

Hi,

Just use this expression :

=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

Report Inappropriate Content · ‎2012-10-01

Hi,

its not working.

I have this fieldname.

Employee Name

Report Inappropriate Content · ‎2012-10-01

already got the answer. thank you..