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

[#1]

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?

[Anonymous · Accepted solution]

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.