Jump to content

Newby, and need help with threescripts...


This topic is 7308 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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 wink.gif" border="0.

-bd

Link to comment
Share on other sites

This topic is 7308 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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