Name Formula

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: sanchezgmc06 — 9 Jun 2016 at 12:42pm

Hello I need help with a formula

the name field brings in the name in the format below
Doe,Jane

however I need to display it :
Jane Doe

how can I do that in a formula?

Posted By: praveeng — 17 Jun 2016 at 2:35am

Hi,

Use Split(DB Field,",")[2] Split(DB Field,",")[1]

--Praveen Guntuka