iansmithwolves
Technical User
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
Ian Smith
Wolves
England
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 strongm 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
- Thread starter iansmithwolves
- Start date
- Status
synapsevampire
Programmer
Try:
if ubound(split({table.field},",")) > 1 then
trim(split({table.field},",")[2])&", "&trim(split({table.field}," ")[1])
else
{table.field}
-k
if ubound(split({table.field},",")) > 1 then
trim(split({table.field},",")[2])&", "&trim(split({table.field}," ")[1])
else
{table.field}
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question