Text Calculation problem

[hartmut]

I have to separate my names in a record . Sometimes there is a "Mrs" or Mr" in the field "firstname" due to an import. I am trying to remove either Mrs. or Mr. from the field firstname and place whichever of the 2 is there in a field called aftername. "Mrs. or Mr. can be followed by the first name so I would like to bring over the first name too. For example the firstname field contains

Jordan Mrs. Bessie L.

I would like to take Mrs. Bessie L. out of the field firstname and put it into the field aftername.

Can someone show me the best way to do this. Thank you

Edited August 31, 2009 by Guest