Splittinga field that has a FULL NAME into two

[papacubby]

Using FMP6 WIn XP

Is there an easy calulation that will take a field that contains a persons full name (George Bush) and pull the first word out (GEORGE). Then I could do the same with the last word (BUSH)? Thus splitting the full name?

When I am done I would have 3 fields: FULL NAME, FIRST NAME, LAST NAME

[Lee Smith]

YourFull Name Field

Left Word(YouFullNameField, 1)

Right Word(YourFullNameField, 1)

Be aware that if the Name is George Von Bush, the Von will not be included.

[QuinTech]

... and if you do want "Von Bush" to appear in the LastName field, you would use the calculation:

MiddleWords ( YourFullNameField , 2 , 64000 )

But bear in mind, this could give you a result like

FirstName = George

LastName = W. Bush

Jerry

[Lee Smith]

Okay Jerry,

You forced me to bring out my heavy artillery.

Hi papacubby,

Take a look at this recent thread. Ignore the reference to [color:"blue"] mktedge.com site , I think it has evolved into something else. But I did attach their file further down in the thread.

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=94866

Lee

[QuinTech]

Ooooo.... i come back from vacation to find you have put me to shame. Cool example.

J