Jump to content
Sign in to follow this  

Rearranging capital words

Recommended Posts

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


Prof Greg I NORMAN

I would like to produce the follwing result

Mr & Mrs JALZ K Abs


Prof Norman I Greg

Is this easily possible?

Many Thanks as always


Share this post

Link to post
Share on other sites

Try this...


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.