Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 8. Understanding Calculations > Replacing Data Using a Calculation
8.7. Replacing Data Using a Calculation
You've worked with the Replace command a few times now. In Chapter 2 (Section 2.3.2), you used it to replace the data in every record with the same value. Then in Chapter 4 (Section 4.2.2.1), you saw how to create data in a key field when your table had records before you created the serial number field. Finally in the box on Using the Index as a Housekeeping Tool, you used a Substitute function to change only a part of the data that's in a field. That's where you really started to see the power of Replace.
Note:
Replace Field Contents is a huge timesaver, but since it works on a found set of records, you can't undo it. Improperly used (with a bad calculation or the wrong found set), it can be destructive. See Section 12.3 to learn how the Data Viewer in FileMaker Pro Advanced helps you preview the results of a calculation before you make that one-way trip through the Replace Field Contents dialog box.
