How to change the phone format to international format/US-format globally for all or a subset of contact records?

Version 1

    Details

    How to change the phone format to international format/US-format globally for all or a subset of contact records?


    Resolution

     

    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