topic Re: Splitting one field into three values - extracting title, name and surname from one field? in QlikView https://community.qlik.com/t5/QlikView/Splitting-one-field-into-three-values-extracting-title-name-and/m-p/600348#M477174 <HTML><HEAD></HEAD><BODY><P>You can do it using the subfield() function.&nbsp; 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.</P><P><BR /> </P></BODY></HTML> Tue, 06 May 2014 12:23:15 GMT Anonymous 2014-05-06T12:23:15Z Splitting one field into three values - extracting title, name and surname from one field? https://community.qlik.com/t5/QlikView/Splitting-one-field-into-three-values-extracting-title-name-and/m-p/600347#M477173 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Any ideas please?</P></BODY></HTML> Tue, 06 May 2014 11:45:55 GMT https://community.qlik.com/t5/QlikView/Splitting-one-field-into-three-values-extracting-title-name-and/m-p/600347#M477173 2014-05-06T11:45:55Z Re: Splitting one field into three values - extracting title, name and surname from one field? https://community.qlik.com/t5/QlikView/Splitting-one-field-into-three-values-extracting-title-name-and/m-p/600348#M477174 <HTML><HEAD></HEAD><BODY><P>You can do it using the subfield() function.&nbsp; 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.</P><P><BR /> </P></BODY></HTML> Tue, 06 May 2014 12:23:15 GMT https://community.qlik.com/t5/QlikView/Splitting-one-field-into-three-values-extracting-title-name-and/m-p/600348#M477174 Anonymous 2014-05-06T12:23:15Z