Split First and Last Names

41812 41
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi all,

I want to use Zapier to export my table to Campaign Monitor but I only need the first name from my primary field which includes the person’s full name (first_name last_name).

Any ideas how I can accomplish this in the table or via Zapier?

I don’t mind creating a first name field and hiding it.

41 Replies 41

Dang it, that was not the answer I was hoping for :slightly_smiling_face: I was trying to save fields in the original table. Thanks kuovonne!

RIGHT(Full_Name, SEARCH(" ",Full_Name)+1)