A HUGE thanks to Steve Wallace who provided me with the info I needed to clean up my address table that included apartment numbers at the beginning of the address (i.e. 123 - 304 Lake Street). Here is the solution:
"Wallace, Steve" wrote: > Okay. You could do something like this. Choose all the records that look > like they have these apartment numbers. Where I use the value '6', use > whatever max rante you think is valid for where dashes might appear within. > > Select * > >From YourTable where > InStr(1,StreetAddressColumn,"-") <= 6 > Into Temp > > Then do an UpdateColumn on Table "Temp" with (dialog would look like): > > Update Column > > Table to Update: Temp > Column to Update: StreetAddressColumn > Get Value from Table: Temp > Value: Right$(StreetAddressColumn, len(StreetAddressColumn) - ( > InStr(1,StreetAddressColumn,"-") + 1) ) > > That should do it! > -- Steve Because my data wasn't consistent with spaces, I eliminated the +1 at the end of the update column equation and then I ran LTrim on the column to eliminate the extra space at the front of the record. Thanks again! This help list is truly efficient and helpful. Have a great day! Sharon -- <>< <>< <>< <>< <>< Sharon Janzen Bibliographic Assistant Brock University Map Library St. Catharines, ON L2S 3A1 http://www.brocku.ca/maplibrary/ [EMAIL PROTECTED] <>< <>< <>< <>< <>< <>< <>< <>< --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11542
