HCarlos

Token function

Discussion created by HCarlos on Feb 27, 2012
Latest reply on Feb 27, 2012 by HCarlos
Hello,
I need to parse some street addresses (stored as strings in one attribute field) to 2 separate fields ??? one for the house number, one for the street name.  Of course the addresses have varying lengths of house numbers (or sometimes none) and varying lengths of street names (and varying word count), so I can???t just use Left() or Right().  For example:


1 Main St
10 Main St
100 Maine Street
100 Main Podunk St
Podunk St  

I think I need to tokenize the string with the space as a deliminator, but I've never used python (and only basic VB scripts), so I'm getting lost as I troll through the various python resources.  Can someone help me out - I'd like to do this in the field calculator.

Thanks,
Heather

Outcomes