Cobra967
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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