Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Splitting one field into three values - extracting title, name and surname from one field?

Hi,

I have a field called applicantName, it consists of Title, Name, Surname, example Mr John Smith. I need to extract title, name and surname from that field in order to use in NPrinting. Some values do not have titles.

Any ideas please?

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Splitting one field into three values - extracting title, name and surname from one field?

You can do it using the subfield() function.  Your expression should be conditional - if there are three parts, they are title, first name and last name, and if there are two parts, only first name and last name.


1 Reply
mov
Esteemed Contributor III

Re: Splitting one field into three values - extracting title, name and surname from one field?

You can do it using the subfield() function.  Your expression should be conditional - if there are three parts, they are title, first name and last name, and if there are two parts, only first name and last name.


Community Browser