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