Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Splitting Name Field: Best Method to Remove Suffix, Middle Names & Prefixes

·

·

What's the best way to split up a name field into First and Last and remove Suffix's middle names and Prefixes?

Splitting Name Field: Best Method to Remove Suffix, Middle Names & Prefixes | Clay

1

7 comments

· Sorted by Oldest

Loading comments

David K.
·
·
https://app.clay.com/workspaces/7778/tables/t_usIc3cnMng1Y/views/gv_fQlNsLmi5blo
Frederik H.
·
·
Hey David, have you checked for the „Normalize First & Last Name“ Recipe?
David K.
·
·
i did but that looked like you need a separate first and last name field
David K.
·
·
i just did this since I texted by using a formula but wasn't sure if there was a better way to do it
Frederik H.
·
·
I mean you can always use a two formulas first to create two new fields „First name“ and „Last Name“ with something like. „Only Return the first name from /NAMECOLUMN“ same for last name. Then use those fields as inputs. Alternatively use open ai step and include some examples in the prompt. Both should work :).
David K.
·
·
ya that is what I did wasn't sure if there was an easier way thanks!
🙏1
Clay Team
APP
·
·
Hey there David sorry for the delay. Will second what Frederik said, formulas are very helpful in these situations, plus are free to use.