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?

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.