.png&w=3840&q=75){kind=logo}
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?
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
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 :).
Hey there David sorry for the delay. Will second what Frederik said, formulas are very helpful in these situations, plus are free to use.