In looking through the scripting section of my FM 5.0, I didn't find a script for separating a text string (three words) in one field, into another. Does anyone know this script?

The next script problem is to add a word to an entire field (without replacing the text contained in it.

The final script is a script that will compare the similar (but not exact)

contents of a field in two distinct files, and return information from one placing it in another field. (I tried linking the files and then looking up the info with no luck!)

Thanks for y6our help,

Rick

1) By "a script for separating a text string (three words) in one field, into another", do you mean separating a three word text string into THREE other fields. If you mean into three fields:

Set Field (Field1, LeftWords(Field, 1)

Set Field (Field2, MiddleWords(Field, 2,1)

Set Field (Field3, RighttWords(Field, 1)

2) Concatenating a word to an existing field:

Set Field (Field1, Field1 & " " & "Dog")

3) There are not very many good ways to do "not exact" matches with computers. Does "Rob" match "Bob" match "Robert"? Does "2.99" match "3.00"? Does "15A First Steet" match "15 First Street"? I think I'm smarter than FM and I don't know the answers .

-bd