Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to get this data from a string?

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..

1 Solution

Accepted Solutions
christophebrault
Valued Contributor

Re: How to get this data from a string?

Hi,

Just use this expression :

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

View solution in original post

3 Replies
christophebrault
Valued Contributor

Re: How to get this data from a string?

Hi,

Just use this expression :

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

View solution in original post

Not applicable

Re: How to get this data from a string?

Hi,

its not working.

I have this fieldname.

Employee Name

Not applicable

Re: How to get this data from a string?

already got the answer. thank you..