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

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?

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


It worked beautifully with toSentenceCase():

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

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.