Is there a way in clay to split this in two fields? I am getting "Full...

Is there a way in clay to split this in two fields? I am getting "Full name" from api - i want it to automatically split into "First Name" & "Last Name"

4 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hey Nikhil, thanks for reaching out! Using conditional formulas would be best for this, here's a quick video on how to use them/set them up - https://www.clay.com/learn/how-to-use-ai-formulas
Clay Team
APP
·
·
To achieve this for full names, you can use a simple prompt for each column and part of the name like: "return the first word from /fullName" "return the second (or last) word from /fullName"
Clay Team
APP
·
·
Let me know if you run into any issues!