Link to home
Start Free TrialLog in
Avatar of Cobra967
Cobra967Flag for United States of America

asked on

Swapping Last and First names in Crystal Reports formula

Hello, I have a single field that lists names always in the following format: Smith, John
Instead, I would like it to read: John Smith
In few words, swap the order of the last/fist name and remove the separating comma in between

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Cobra967
Cobra967
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of James0628
James0628

FWIW ...

 That will work as long as the name is always in that format.  But if there could be times when the field doesn't include a comma (including if the field is blank), you'd need to check for that or you will get an error.  And if the field could ever contain something like "Smith, Jr., John", you'd get "Jr. Smith", so that would complicate things.

 James