adding text to a column

[filemaker2001]

Hi,

I'm sure someone has answered this query before, but I have FM5.0 and I would like to run a script that either removes the first word of a text stream or conversely, adds a (the first) word into an entire column.

Thanks for the help.

Rick

[LiveOak]

What exactly do you mean by "text stream" (text field?) and "column" (table --> file and column --> field?). Neither of these terms has any exact meaning in FM.

-bd

[Vaughan]

Errr, this is a scriptmaker question, why is it in the Define Fields Forum?

Anyway, use the Set Field[] or Insert Calculated Result[] script steps to perform the magic.

It could also be done with a calculation field, using exactly the same function as in the Set Field[] step. The advantage of the calc field is that it will instantly be updated, without having to wait for a script to be run.