You could update your column by first querying for the irregulars (MYFIELD like "%/%")and then use the Mid$ command to update. It would look something like:
Mid$(MYFIELD,2,50,1) That may not be right, but close. The first number tells it how many characters to crop from the left, the second number tells it how many characters to include, and the third tells it how many characters to crop from the right. As long as none of your records have more than 50 characters the above statement will turn 1/65 Plimsoll Place into 65 Plimsoll Place PROVIDED YOU ARE UPDATING A QUERY THAT RETURNED ALL OF THE REGULARITIES FIRST. If you run that on your entire table, it will delete the first two characters from all of your records. I usually make a backup of my table before attempting. Hope this helps, and feel free to correct me if I got the statement wrong. Ryan Morgan Aerials Express www.AerialsExpress.com -----Original Message----- From: Chong, Austin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 11:04 PM To: Mapinfo-L (E-mail) Subject: MI-L how to geocode 1/45 xxx Street automatically and successfully??? Importance: High To all the 'geocoding experts': Thanks a lot for those who have contributed to my previous question. I have one final question for the day and probably the most significance question. Addresses such as 1/65 Plimsoll Place will not be able to geocode automatically where 1 represents the unit number of house number 65 in Plimsoll Place. Is the a way to reconfigure the abbreviation file (perhaps using substitution or truncation) such that it can be geocoded automatically? Accuracy is not a problem here. I really don't mind if I can set up the abbreviation file such that it reads 65 Plimsoll Place (not fuss about the unit number at all). Thank you very much. Regards, Austin Chong --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5344 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5368
