Script to copy word from field, delete from other?

[ibiubu]

Is there a way to have a script that will copy the word that is in a field, go to another field, and delete that word from the text in that field?

LR

[Kurt Knippel]

Replace ( TextField, gWordtoReplace, "" )

This will replace all occurances of gWordtoReplace with "" (blank) in the text of TextField.

[ibiubu]

Great. Can it also be set to delete carridge returns? For example if the text is entered in the field like this:

James

Larry

Sam

Taylor

Can it be set to delete Sam so that what is left behind with returns is:

James

Larry

Taylor

LR

[BobWeaver]

I think Captkurt meant to use the Substitute function, not the Replace function.

Yes you can delete the carriage return with this formula:

Substitute(Substitute(TextField,gWordtoReplace,""),"

[ibiubu]

Gave it a whirl...Now that was a GREAT script!