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)