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?