Formula to extract first name and apply Title Case: "CLARA SMITH"=>"Clara"

[fxholl]

I often need to extract the first name from a full name in all caps (“CLARA SMITH”) and convert it to title case (“Clara”)

Is there a simple way in n8n to do that?

[pemontto]

You can .split(' ')[0] on the space char to get the first name, and use the handy data transform function to title case it Data transformation functions for strings | n8n Docs

[fxholl]

It worked beautifully with toSentenceCase():

{{ $(‘Split In Batches’).item.json[“salesperson_name”].split(" ")[0].toSentenceCase() }}