Split Words into seprate fields

[Corey-Troy]

I have a field with an employees full name (Christian Name and Surname).

I know i can use a

LEFT(Full Name Field;1)

to get the first letter of a word.

But is there a way to split an entire word into another field.

I want to have a value list attached to a field, this will list the full names of employee's.

I also want to have 2 separate fields, lets say Field1=Christian Name, and Field2=Surname.

Is there a way when a full name is selected from the value list, that the Christian name is placed into Field1 and the Surname is placed into Field2 without manually typing them in?

[comment]

How about:

LeftWords ( FullName ; 1 )

[Corey-Troy]

Thank You.

Just as i clicked post, i found the LeftWords, and RightWords.

Cheers.

Corey....

[comment]

Good. Watch out for stuff like "Jean-Paul Sartre", "Elizabeth Brown Smith" etc.

[LaRetta]

Is there a way when a full name is selected from the value list, that the Christian name is placed into Field1 and the Surname is placed into Field2 without manually typing them in?

It would work well to split the data first (using the xWords method). Value lists should select the CustomerID in the first field (you DO have a unique serial for your table, right?) and then the second field would be a calculation where you have concatenated the two fields together as FirstName & " " & LastName.

[FMPierce]

Is there a way to sepperate all the words so if i wanted to have a calc, say, take the first letter of every word and put it at the end of the word so "Help!" would become "elp!H"?

Thanks!

FMPierce

:ninja:

[comment]

take the first letter of every word and put it at the end of the word

Actually, Filemaker counts "Help" (with no punctuation) as a word, so the result would be "elpH!". In any case, it would require a custom function - and not a very simple one.

[FMPierce]

Oh. I am making a DB to do exactly that (Without punctuation), though it can only handle 100 words at a time, it has 4 fields, 3 are repeating fields with 100 repetitions each.

Field #1 = Text, entry

Field #2 = Number, numbers 0 through 100

Field #3 = Calculation, LeftWords ( Extend ( Field #1 ) ; WordCount ( Extend ( Field #1 ) ) - Field #2 )

Field #4 = Calculation, RightWords ( Field #3 ; 1 )

So Field #4 is equal to word Field #2 of Field #1.

So if Field #2 = 0 and Field #1 = "FileMaker 11 Advanced", Field #4 Would equal "Advanced"

BTW. How do you insert a Photo?

[comment]

Oh. I am making a DB to do exactly that

???

[FMPierce]

:sorrysign: I just said something COMPLETLY un-related to your post, yet I referred to your post. rrrrrrgggg!

OK, I am making a DB that can take the letters of each word scramble them in a controlled way to "encode", so to do that I needed to split all the words into separate fields.

[comment]

I just said something COMPLETLY un-related to your post

I thought it was unrelated to your post - or any post in this thread.

[FMPierce]

rrrrgggg again! :bang: