Need help on breaking a Full name into First Name, Last Name

[toblerone65]

Frieds I have a field Firstname,Lastname i like write a formula to break it into First Name and Last Name as two separate fields. Thanks in advance for your time and help.
Toby.

 

[lbass]

Create two formulas:

//{@oneofthenames}:
stringvar x := {table.fullname};
split(x,",")[1]

//{@theothername}:
stringvar x := {table.fullname};
if ubound(split(x,",")) >= 2 then
split(x,",")[2] else
x

Usually, a name field with a comma is "LastName,FirstName".

-LB

 

[toblerone65]

LB thanks so much, it works like Charm!!!, thanks so much for your time
Tob