Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display LastName, FirstName as FirstName LastName

Status
Not open for further replies.

pleashelp

Technical User
Feb 27, 2002
97
US
I am using CR XI. I think I have seen this discussed on the forums a long time ago. But I can't find the answer, so I'll ask it again. I have a string that shows a person's name as Lastname, FirstName. I want to display the field as FirstName LastName. Can someone help me with this?
 
trim(split({@Text},",")[2])
&
" "
&
trim(split({@Text},",")[1])

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top