Question

How to split a full name field into separate first and last name fields?

  • 20 May 2021
  • 5 replies
  • 2509 views

Userlevel 1
We're working with Facebook Lead Ads and Shopify.Only the full name can be selected.Is it possible to separate the surname from the first name?Why aren't there options on Facebook lead ads when they can be separated?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Badge +4

Hi @Michael.S,

Use a Zapier formatter step to split the text to get the separate name values that you want. In the formatter step select ‘text’. Then split text option...

 

Hope this helps!

Happy Zapping!👍🤓

 

Userlevel 7
Badge +14

Hi @Michael.S 

One thing to keep in mind with names is there there won’t always be just a first name and last name.

Sometimes people have multiple first names or last names, include a middle name, have a prefix like Dr., include a suffix like Jr., etc.

Just something to be aware of using Formatter > Text > Split.

Userlevel 1

Thank you! XRay!

Is this setting correct?

 

Which should Shopify set?

Userlevel 1

Thank you! Troy!

I agree.

However, in the case of Japanese, there is no middle name.
It's just the first name and the last name.

 

Just something to be aware of using Formatter > Text > Split.

 

This should pay attention to the characteristics of the entered character string.
Do you agree with the recognition?

 

For example
XRay, who gave me some advice,

He told the separator [: space:].

Is this something like this?

 

 

 

Userlevel 7
Badge +14

@Michael.S 

Yes, the advice @XRay Tech provided is correct.

TIP: When in doubt, test it out!