Community
Showing results for 
Search instead for 
Do you mean 
Reply

Replace character string in a field

Copper Contributor
Posts: 56
Country: USA

Replace character string in a field

I have a lot of records that have Mr.. or Mrs. as the beginning of the contact field. I would like to delete this string of characters with out deleting any of the name. I want to make "Mr. John Q Public", into "John Q Public" in the contact field.

In essence, I want to delete this string of characters and replace it with nothing.

 

How do I do this in Sage ACT! Pro 2011 Version 13.0.401.0, Hot Fix 2? Do I need to buy an addon product, or a plugin to do this?