Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

split name surname in separate column

Hi, I went to the forum, but I have not found anything that suits my case. I have a colum like this ( name and surname) MARCO DI BENEDETTO MICHELE DE ROBERTO I'd like to split into 2 separate col...
Need Help
Tutorial Requests
Gengar's avatar
Gengar
Icon for Resolver I rankResolver I
3 years ago

Hi Anonymous ,

 

This is my data:

You can create two calculated column:

 

_name = LEFT([Name],FIND(" ",[Name])-1)
 
surname =
VAR NAME1 = RIGHT([Name],LEN([Name])-FIND(" ",[Name]))
VAR NAME2 = RIGHT(NAME1,LEN(NAME1)-FIND(" ",NAME1))
return NAME2
 

 

Hope my answer could help you!

Ganger

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Ehm, in your solution we lost part of surname (DI or DE), correct surnema is

    DI BENEDETTO

    DE ROBERTO

    ...that's my headache! 😉