robkay21

Split address string field

Discussion created by robkay21 on May 22, 2012
Latest reply on May 23, 2012 by mdenil
Hi Everyone,
I've got a street address field with the suburb name attached.  I need some help writing a script that splits off the suburb then writes the address and suburb to seperate fields.
eg.  13 Kent Street Gordon
I want the field split like this: Address (field name): 13 Kent Street          Suburb (field name): Gordon
Not all the suburbs are single words so I can't just split off the last word.  The only way I think it may work is to search for the words 'Street, Road, Avenue, Lane, etc. (I've made a comprehensive list) then split the string after these words once they are found.
Is this possible?
Cheers
Rob

Outcomes