first last name calc

[_samuel_]

Hello everyone,

I inherited a database with a field that included the names of contacts in this format: "LastName, FirstName"

I know there has to be a simple calculation to reverse that to "FirstName LastName", but I cannot figure this out. Please help. Thanks.

[comment]

there has to be a simple calculation to reverse that to "FirstName LastName"

Yes, there is. But I would suggest you split the names into separate fields first; then you can combine them any way you like using calculations.

LastName =

GetValue ( Substitute ( FullName ; ", " ; ¶ ) ; 1 )

FirstName =

GetValue ( Substitute ( FullName ; ", " ; ¶ ) ; 2 )

[_samuel_]

Wonderful. Thank you, Comment. It worked great!