Jump to content
Sign in to follow this  
Jalz

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

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

Share this post


Link to post
Share on other sites

Try this...

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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