Copy contents from 1 field to another

[gfr92y]

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

[eos]

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, 2015 by eos

[comment]

This part is indeed not clear:

  On 5/13/2015 at 10:13 PM, gfr92y said:

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

​

And neither is this one:

  On 5/13/2015 at 10:13 PM, gfr92y said:

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?

 

 

[gfr92y]

All, Sorry for being so stupid!

EOS, Thanks. Your answer was incredibly helpful.

Joe

[Josh Ormond]

  On 5/17/2015 at 3:39 AM, gfr92y said:

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.

[gfr92y]

Josh,

Thanks! 

I appreciate the encouragement.

Joe