Community
Showing results for 
Search instead for 
Do you mean 
Reply

Anyone know of a 3rd Party Add-On that can do specific find and replace?

New Member
Posts: 28
Country: United States

Anyone know of a 3rd Party Add-On that can do specific find and replace?

All,

In our 8,000 record ACT database, we have fields that point to folders on our server. For example, we may have a field for scanned documents. In that field might be file://S:\scans\Anderson

We now have so many folders in that directory that we need to separate them out in sub folders. So ..

file://S:\scans\Anderson

would be:

file://S:\scans\A\Anderson
(notice the subfolder A)

 

All we would need is a query that would go in and look for "file://S:\scans\A" and replace it with "file://S:\scans\A\A" and leave the text after it alone. We would have to do this for each letter but that would not be an issue.

 

(We have 5 fields like this so it manually it could be 5 x 8,000 = 40,000 records to change)

 

Any suggestion for an automated way of doing this?

 

Thanks!!

Bronze Contributor
Posts: 955
Country: Australia

Re: Anyone know of a 3rd Party Add-On that can do specific find and replace?

If you go to Designr1.com they have an addin swiss army knife whihc I believe is capable of this change

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
New Member
Posts: 28
Country: United States

Re: Anyone know of a 3rd Party Add-On that can do specific find and replace?

Amazing!!!

Thanks so much. That is EXACTLY what I needed.

 

Thanks again!