Community
Showing results for 
Search instead for 
Do you mean 
Reply

Mass Phone Number Formatting

New Member
Posts: 7
Country: United States

Mass Phone Number Formatting

I'm a newb, and this is probably covered elsewhere, but here it is. I just transitioned a small company from Goldmine 6.7. All went fairly well considering. Now we're in the cleanup/fixup phase, and one of the areas is phone numbers which are inconsistently formatted.

I have a development database to which I can try global search and replace, or data formatting processes, but I don't know how to do this with ACT! 2008. 

The formatting is currently set to Free Form. There is a pre-defined format, [United States] that appears to do what we want to do, but don't know how to apply it globally to the field. 

Any help would be appreciated.

 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Mass Phone Number Formatting

Please see the following Knowledgebase article:

 

How To Replace Phone Format For Multiple Records

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.