Clay Icon

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?

  • Avatar of Frederik H.
    Frederik H.
    ·
    ·

    Hey David, have you checked for the „Normalize First & Last Name“ Recipe?

  • Avatar of David K.
    David K.
    ·
    ·

    i did but that looked like you need a separate first and last name field

  • Avatar of David K.
    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

  • Avatar of Frederik H.
    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 :).

  • Avatar of David K.
    David K.
    ·
    ·

    ya that is what I did wasn't sure if there was an easier way thanks!

  • Avatar of Clay T.
    Clay T.
    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.