Splitting full name into separate fields on export

  • Profile Image
    aspirebrokers
    Asked on April 05, 2016 at 10:08 PM

    Hi Guys,

    I like the formatting and look of the "Full Name" field however I need the data to come out of the system in separate fields.  Is there a way I can do this?

  • Profile Image
    liyam
    Answered on April 06, 2016 at 12:16 AM

    Hello aspirebrokers,

    If you're simply going to split the parts of the full name for the purpose of separation on email alerts, it can be done by modifying the email alert template. And for the specific full name field, separate it with a colon. Example: {fullName:first} {fullName:last}

    When using {fullName} alone, it will show the proper full name such as John Doe. But, when using {fullName:first}, it will only print John. However, this is only limited to printing the information to your email alerts or your thank you page. 

    So if you wish for the name to split in an excel data, you will have to make use of the regular text box instead and have the fields set for each part of the name per text box. This way, each part of the name will be separate from each other.

    Please let us know if you have further questions.

    Thanks.