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!

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

Changing order in field

Status
Not open for further replies.
iansmithwolves

iansmithwolves

Technical User
Jan 24, 2003
53
0
0
GB
I have a field with user name in (surname,first name) format. Is there a formula which will change it to (firstname, surname) format

Ian Smith
Wolves
England
 
Sort by date Sort by votes
Try:

if ubound(split({table.field},",")) > 1 then
trim(split({table.field},",")[2])&", "&trim(split({table.field}," ")[1])
else
{table.field}

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
74
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
139
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
88
SoftwareRT
SoftwareRT
Niki_S
  • Locked
  • Question
Create crystal report according to a specific order
Replies
1
Views
54
kray4660
kray4660
Niki_S
  • Locked
  • Question
Create crystal report to specific order using foxpro 1
Replies
0
Views
38
Niki_S
Niki_S

Part and Inventory Search

Sponsor

Back
Top