Hi,

I am new to this forum. I have a cross platform database done in FMP 6. It runs on OSX and Windows XP. I have created a field that is the result of adding the text from several fields. I set it up using the "set field" script. The resulting text field is over two pages long. I want to be able to select and copy "x" amount of characters into a different online database progam. Any suggestions?

Thanks for any help you can give me.

dmr26,

This should be easy. Calculations like

Left(YourLongField,500)

or

LeftWords(YourLongField,120)

are designed to do this kind of thing (as with their Right and RightWords and Middle and MiddleWords counterparts). You can have a global field or any other calc field in place of the actual number, if you want to change the number on the fly. Of course, getting that result into "another online database" (not FM?) depends entirely on what that other database is...

BTW, any reason that you're using "set field" to get this initial result rather than making a lookup or calc field? (You probably do have reasons, but since you're new to this forum, I thought I'd ask.)

Hello dmr26,

If, as you say, your objective is "to be able to select and copy 'x' amount of characters", then taking Elise's comments a step further, I suggest that you create a global text field as a utility field, then set up a script as follows:

Set Field ["gTempTxt", "Left(YourField, x)"]

Copy [select, gTempTxt]

That will get you the required portion of the field contents copied as you requested. Where you go from there (and how) depends on a variety of factors you've not shared with us...

Thanks Ray and Elise

The field of text may result into two or three pages. I want to copy one page at a time and paste it into an online database. The online forms database only allow a certain amount of characters (I am still finding out how many.) How would I write the script so that it copies the first page so that they can paste it into the online database....... and then the second page .......and then the third page. I appreciate your help.

Diane