Reverse String

Mun · Post by **Mun** » Tue May 23, 2006 7:04 am

Hi,

I am trying to reverse first name and last name.

ie: Doe John -> John Doe
or Jane Mary -> Mary Jane

ArndW · Post by **ArndW** » Tue May 23, 2006 7:12 am

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)

DSguru2B · Post by **DSguru2B** » Tue May 23, 2006 7:13 am

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)

Mun · Post by **Mun** » Tue May 23, 2006 7:37 am

Perfect!! You guys ROCK!!! :D