Rearranging capital words

[Jalz]

Hi Guys,

I have field which contains thousands of lines of data. I am interested in rearranging one particular field, the name field. The name field seems to be jumbled and what I am trying to do is get the contents of that field in the following order

Mr SURNAME, Inital Forename

One thing about the data is the surname is always in capitals.

Imagine this is the data in field name

Mr & Mrs JALZ K Abs

BLOGGS Fred Mr

Prof Greg I NORMAN

I would like to produce the follwing result

Mr & Mrs JALZ K Abs

Mr BLOGGS Fred

Prof Norman I Greg

Is this easily possible?

Many Thanks as always

Jalz

[Ocean West]

Try this...

http://www.fmforums.com/forum/showtopic.php?tid/173134/post/190406/hl/%22Universal+Capitalizer%22/