How to change the phone format to international format/US-format globally for all or a subset of contact records?
Please note: It is highly recommended to complete a full SQL database backup of the GoldMine database before performing a global replace.
Log in with master rights (otherwise the Status field will not be available for a global replace)
1. Click Tools >> Data Management >> Global Replace
2. Choose Update a field using advanced options >> Next
3. Choose the status field in the Update field drop down
4. Choose the option to Evaluate Value as dBASE expression at the bottom of the dialog
5. Enter: "I"+substr(contact1->status,2,2) in the Expression field under the Update Field drop down if you want to change all records to international format, enter: "U"+substr(contact1->status,2,2) in the Expression field under the Update Field drop down if you want to change all records to US-format
6. Click Next
7. Verify the correct fields to be replaced is listed >> Next
8. Verify a filter of contact to run the global replace against or choose All Contact Records for the entire database
9. Click Next
10. Click Finish