First and Last Name from Subject Name

Create a First Name detail and a Last Name detail in ETO Results #Results

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 Subject ID. Change the qualification to a 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?