Personalization, Customization and Productivity Tools

[mblocker1]

In payroll there is only first name field which includes middle initial and period. Need to be able to take John A. (every employee with middle initial has a space between first name and ends with period) and split into two fields one for John and one with just the A and not the space for middle initial. similiar I need to separate last name field which contains last name and suffix so for example Smith III needs to be two fields one with Smith and one with III (every last name with suffix is separated by a space)

[Gator]

Assuming you are talking about crystal reports...

FirstName:

if InStr({PR1_EmployeeMaster.FirstName}," ")>0 then Left({PR1_EmployeeMaster.FirstName},InStr({PR1_EmployeeMaster.FirstName}," ")-1) else {PR1_EmployeeMaster.FirstName}

MiddleInitial:

if InStr({PR1_EmployeeMaster.FirstName}," ")>0 then Replace(Mid({PR1_EmployeeMaster.FirstName},InStr({PR1_EmployeeMaster.FirstName}," ")+1),".","") else ""

The other two will be similar.

[mblocker1]

Thanks that worked!