Rocky Smolin
rockysmolin at bchacc.com
Wed Sep 14 22:43:58 CDT 2011
Arthur: How many records need to be processed? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: September 14, 2011 8:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Numbers within a street Hi Arthur: Fixing data is as hard as writing the program. I would slowly extract the data and fix the data one pass at a time. Checking to see that there is no weird results, after each pass...you might have to go in and do some manual fixes, as there are always records that defy any translators (and there is no point writing 100 lines of code to fix 10 records). Depending on the complexity of the data and your code, 3 to 5 passes is not unusual before a clean set of data can be obtained. Many years ago, I wrote a "riding" application, which would put a canvasser's data into the correct poll just from a poll's legal description. If you need any assistance, I would be glad to help. I also have the appropriate credentials, heritage and my official retirement is close at hand. ;-) You can contact me off line, if you would like. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, September 14, 2011 1:31 PM To: Access Developers discussion and problem solving Subject: [AccessD] Numbers within a street I am working on a political campaign management app. The thing I need to do is post reports that identify the even and odd numbers on a given street. I inherited the db and have freedom to change it (it was written by amateurs and they know it and there are no hard feelings if I make a change, insofar as said change increases productivity). So... given a current field called StreetAddress, I want to break it into two fields, StreetNumber and StreetAddress, so that I can filter the even numbers for one report and the odd numbers for an identical report. How can I intelligently extract the data and populate my new columns? Example data: 123 Normal Street ' easy 234A Abnormal Street ' a tad trickier 2333-1070 Queen Street ' the 2333 part should fall into the StreetNumber field and the rest into the StreetAddress field. Any clever ideas how I might achieve this? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com