I need to make changes to the puncuation on each data entry. Is there a search and replace facility or will I have to do this manually for each record?

The Find and Replace feature wasn't available until FMP v6.

You can accomplish the same thing by using the Substitute Function. You can access the Substitute Function in two ways. Either using the Replace via the Menu - Records - Replace (Cmd + =, on a Mac, and Ctrl + = Windows), or by using it in a Script Step.

I usually access it via the Menu for those occasional needs, and use the Script when it is an often need.

Menu.

1. Isolate the record or records to be changed.

2. Put you cursor in the field to be changed, and hit the Key Combination, or go to the Menu.

3. Select the Option "Replace by Calculated Result" and hit the Specify button.

4. You will then get a Calculation box. In it, you will need a calculation such as:

Substitute(YourField, ";", ",")

[color:"blue"]

Thanx, Lee! I didn't know about Substitute...

Hi, hilmarton! Before seeing Lee's post, I would have just exported the data into text, opened it Word, made the corrections, and re-imported the data.

--ST

Thanks Lee. We'll give it a go!

Thanks. We'll give it a go!