01-24-2017 09:31 AM - edited 01-24-2017 09:31 AM
All, I have several thousand county parcel numbers that contain dashes 123-456-789. I need to remove these dashes, en mass.
Anyone have any suggestions? Jim
01-25-2017 08:09 AM
02-09-2017 07:44 AM
"Could you let us know what version of Act! you're using?" Act! Ver 18 Premium
"Could you list the exact steps you're taking in your 2nd scenario, and when exactly the error occurs." Gary, exactly that, I just created and new Parcel Number field and then used the copy feature trying to copy from the original Parcel Number field to the new field.
"In regards to manipulating the data to remove the dashes, this would not be possible by just using Act." Appears to me that within ACT it just is not going to work.
I dont think I want to use the Excel feature, If the contacts/parcel numbers do not import exactly, then I'll have an even bigger mess on my hands. Thanks Jim
02-09-2017 08:10 AM
My company, DesignR1, has a product called Swiss Army Knife which is meant for exactly this sort of thing. I just tested it by copying phone numbers into the User1 field in the demo database and then removing the dashes from User1, and it worked great. Here is the configuration I used:
(Note that the last box is empty. In this case, we're replacing the dashes with nothing. You could replace them with spaces, or commas, or whatever else.)
The trial will only allow you to change up to 20 records at a time, so just be aware of that limitation. You can download it from http://www.designr1.com/shop/swiss-army-knife-2/
02-09-2017 08:38 AM
02-12-2017 04:39 PM
I've imported Excel files into Act dozens of times. This needs to be exact so that I don't add more contacts records on the re-mport. Today I did export about 1900 act contacts into Excel. In Excel I have the parcel number that contains the hyphens in one of the column. I then created a duplicate column just to the right of this first column and copied all of the parcel numbers to that column, Parcel2. Then I removed the hyphens from that second column. I did not remove column containing the original parcel number with the hyphens, I wanted to use that as my duplicate checking field on the re-imported. I re-imported the numbers into ACT using a newly created Parcel2 field in Act. So now I imported the original parcel number (containing the hyphens) and a second parcel field containing the corrected number (without the hyphens). Then I simply copied the Parcel2 to to my original parcel number field, seemed to work perfect. Thanks for helping. Jim