I have a field containing about 29,000 records called ADD_SHOR_2 that contains address values.
Example: 352 W 600 N
I need to parse/trim each address at the first space so that the address becomes W 600 N.
I have looked around for a while now, but can't seem to find the most efficient way to calculate the 29,000 records so the house numbers are trimmed off.
Can someone please help. I am just working with ArcView 10.
I know how to export the table to an excel-compatible file, and do "text to columns" in excel, then join the table back to the original shapefile using a field that contains unique identifiers, but I think there should be an easier way to do this.
Thank you for your help!