Jalz Posted April 26, 2007 Share Posted April 26, 2007 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 Link to comment Share on other sites More sharing options...
Ocean West Posted April 26, 2007 Share Posted April 26, 2007 Try this... http://www.fmforums.com/forum/showtopic.php?tid/173134/post/190406/hl/%22Universal+Capitalizer%22/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6209 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now