I need to split fullname into first and last

[marni]

Hi,

I have a field that gets the fullname of a user form their Stripe account, but now I want to extract the first name and the last name. Basically I want to do a calculation that will return it. Or I am open to other ways of achieving this.

Thanks in advance.

[luke2]

Hi @marni,

I posted something a while back that might do just the trick:

Quick regex extract for first and last name

Hi Guys, Just a quick tip for extracting the first and last name with a regex pattern using the :item expression. [image] Regex pattern: ([^\s]+) Demo: [extract-names] Conditions could be used if the person just enters a first name or even if they enter a middle name… Cheers

Hope that helps…

[marni]

that worked thanks!