change field text from "A" to "B"

[onecolor]

Hello, I have a field called "notes", it contains text "enter your note here". If a user adds something they'll change "enter your note here" to "blah blah". What I'd like to have is a script that looks at field "notes" and if it contains "enter your note here" it will changes it to " ", and if contains anything other than "enter your note here" it leaves it alone. This sounds easy enough in my mind, but I can't seem to write it out to work. Thanks in advance.

Paul Perry

[cjaeger]

set field [notes, if(exact(notes,"enter your note here"),"",notes]

or use replace() instead for all records in the found set.

EDIT: that is substitute, sorry. (I am working with German FileMaker)

Have you ever thought of using a calc field placed above or behind the (transparent) note field with formula:

if(isempty(notes),"enter your note here","").

Or just telling your users that they should enter notes where there is a field labeled "Notes:"?

[LiveOak]

Set Field [yourField, Substitute(yourField, "enter your note here", "")]

-bd

[onecolor]

man that was quick. Thanks so much