Easy formula - I just don't know syntax

[RedHeadedStepITChild]

I am using Crystal XI - DB2 database.

I am doing a database conversion project, and using Crystal report to export as a CSV for the new database.

The new database has two separate fields for the employee name, where our current database just has one field.

The data in our current database is set up as lastname comma space first name. For example: Doe, John

I am thinking that I need two formulas - one to include everything up to the comma, and the second to include everything after the comma. Should be easy for you pros out there

 

[RedHeadedStepITChild]

I figured it out

Stringvar LastName := {Field.Name};

While Instr(LastName,",") > 0 Do
(
LastName := Left(LastName, Instr(LastName,",") -1);
);
LastName