Philip Jenks Posted July 18, 2011 Share Posted July 18, 2011 Hi I've just done a stupid thing. I had 120,000 records, some of which had an entry in Address 2 but not in Address 1, and it annoyed me. So, to shunt the address upwards, I did a search for empty Address 1, then ran a script which copied Address 2 into Address 1, when what I should have done is CUT from 2 to 1. The result is that somewhere among those 120,000 records I have about 55,000 records which have the same text in Address 1 and Address 2, and since I didn't notice till some time later, I don't know how to identify the 55,000 and delete the text in 2. I tried creating a calculation field which subtracts 2 from 1, and hoped that this would result in a unique number which I could then use, but that doesn't seem to work. The fields do have '0' in that calculation field, but so do lots of other records with non-identical 2 and 1. Anyone got any better ideas? Grateful for your advice. Thanks. Link to comment Share on other sites More sharing options...
Raybaudi Posted July 18, 2011 Share Posted July 18, 2011 Create a calculation field: Exact ( Address 1 ; Address 2 ) and, in find mode, search that field for 1. Then you'll be able to replace Address 2 with empty Link to comment Share on other sites More sharing options...
Philip Jenks Posted July 19, 2011 Author Share Posted July 19, 2011 Hi Raybaudi Problem solved! Thanks very much. Saved me a lot of hassle. Philip Create a calculation field: Exact ( Address 1 ; Address 2 ) and, in find mode, search that field for 1. Then you'll be able to replace Address 2 with empty Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4686 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now