tysonbarlow

PARSE/TRIM AN ADDRESS TEXT FIELD

Discussion created by tysonbarlow on Jun 3, 2011
Latest reply on Jun 6, 2011 by tysonbarlow
Hi,

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!

Outcomes