Post

2 followers Follow
0
Avatar

using calculation to pull the first and last name out of a text string

Hi, I am trying to pull the first and last name out of a text field.  Is there anyone that can help me with the right calculation to do that for this type of full name?  The Last Name is the "Fuchs" and first name is "Jennifer".  Thank you for your help!

Michael Faurest

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Michael,

last name:

@Full Name.split(",")[0]

first name:

String(@Full Name.split(",")[1])

Rainer

Rainer Grabowski 0 votes
Comment actions Permalink