Community
Showing results for 
Search instead for 
Do you mean 
Reply

Change ACT fields from all uppercase to propercase

New Member
Posts: 1
Country: USA

Change ACT fields from all uppercase to propercase

Is there a way in ACT 10 to convert fields where the data is in all uppercase format to all propercase format? I imported my predecessors Goldmine database into ACT 10, but he used all uppercase. My mailing service is requireing me to change the format, which I can do easily in Excel, but I can't import it back into ACT without losing my history and notes. I would think this might be a common problem and hope someone else has already solved it Smiley Happy
Thanks!
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Change ACT fields from all uppercase to propercase

I don't know a tool to do this in ACT!, but if you've done it in Excel, you can import it back in with itImport without losing the other data
Nickel Elite Contributor
Posts: 595
Country: USA

Re: Change ACT fields from all uppercase to propercase

You might want to check this addon.
 
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Change ACT fields from all uppercase to propercase

Nickel Elite Contributor
Posts: 595
Country: USA

Re: Change ACT fields from all uppercase to propercase

According to Greg (he wrote the program) it does. I think it is through a selective replace.
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Change ACT fields from all uppercase to propercase

Ahhh... useful to know. You might suggest to him that if not on the site, at least the manual should have a more complete list?
 
I miss the old OakCheck! :-)