All Collections
ETO Results 4.3
Formulas and Objects
ETO Results | Retrieve First or Last Name from Subject Name
ETO Results | Retrieve First or Last Name from Subject Name

Bo 4.3 Platform

Updated over a week ago

If you are using the Standard TouchPoint Universe for a query, you can create details to pull First Name and Last Name from Subject Name.

Create a variable (you can call it First Name Detail or something similar). You will need to have a merged object in your report, preferably a Subject ID. Change the qualification to detail and use the merged object as the associated dimension. From there, use the formula below. Repeat steps for Last Name Detail.

  • First Name:
    โ€‹=Right([Subject Name];Length([Subject Name])-Pos([Subject Name];" "))

  • Last Name:
    โ€‹=Left([Subject Name];Pos([Subject Name];",")-1)

Did this answer your question?