How to change all of field data

[yonocomprehendo]

Does anyone know an easy way for me to create a script that will change all the data in one data field? For example, say i have something in some of the fields that says 1, but i want all the things that say 1 to be number1, how would i do this using scriptmaker?

[Fitch]

Set Field [somefield, "number1"]

[Lee Smith]

Hi,

I'm not sure I'm understanding you exactly.

Substitute 1 with "Number 1"?

In FileMaker 6, use the Menu - Edit - Fine/Replace

In earlier version, use the Replace by calculation:

Caution, this can not be undone.

Place the cursor in the field with the text.

Go to menu Records - Replace (Cmd + "=" on a Mac)

When in the Replace Menu click the Specify Button (Replace with Calculated Result) the calculation will be:

Substitute(YourFieldName, "1","Number 1")

Put the name of your field in place of YourFieldName.

Click okay,

Click Replace

HTH

Lee

[yonocomprehendo]

Thanks for the help, i reallyb apreciate it!