Hi,
I am trying to reverse first name and last name.
ie: Doe John -> John Doe
or Jane Mary -> Mary Jane
Reverse String
Moderators: chulett, rschirm, roy
If your name field always has just one space in it (which is highly unlikely) then it would be FIELD(In.ColumnName,' ',2):' ':FIELD(In.ColumnName,' ',2)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Make sure the first and the last name have a single space in between. Use the Field functionality to strip the first and last name and then cat them together with a space in between. Something like
Code: Select all
Field(in.name,' ',2):' ':Field(in.name,' ',1)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.