I have 9,000-record db with 147 records that have entries in the cells of one field that need to be "fixed".

I created a calculated field that "fixes" the entries of each cell in the field.

Can I now copy the contents of the fixed (Calculated) field for all 147 records to the original field?

Thanks!

Joe

What are “the cells of a field”? [Repetitions of a repeating field?]

Well, whatever they are, examine the “Replace Field Contents” command / script step and see if that is what you need.

http://fmhelp.filemaker.com/fmphelp_13/en/html/add_view_data.4.49.html#1053099

If you experiment with that feature, make sure to do it on a copy of your database first; there is no Undo.

btw, it usually easier to give advice if you don't describe your situation in abstract and/or generic terms.

Edited May 13, 201510 yr by eos

This part is indeed not clear:

II created a calculated field that "fixes" the entries of each cell in the field.

​

And neither is this one:

I have 9,000-record db with 147 records that have entries in the cells of one field that need to be "fixed".

​What does the calculation field return for the remaining 8853 records?

 

 

All, Sorry for being so stupid!

EOS, Thanks. Your answer was incredibly helpful.

Joe

All, Sorry for being so stupid!

​Never call yourself ( or anyone ) stupid.

We are all learning my friend. Somethings may not always be so obvious. I know I've been there at times myself.

Just make sure whenever you do stuff like you are talking, do it on a copy of the file that way if it all goes wrong...you can restore the original file, and try again. Without ruining your data.

Josh,

Thanks! 

I appreciate the encouragement.

Joe