/
Address Element Extraction:

Address Element Extraction:

Owned by Charles Fox
Last updated: Aug 09, 2013Version comment

Synopsis

Notes on extracting the City, State, Postcode from clumped address like the Shipto Address in MYOB. 

 

Suggested definition format from Jace.

Ok, if we have another table which has the mapping something like the following:
Schema, Country, Source Table, Source Table Key, Source Table Address Field (Assume a clumped address, or a comma-delimited set of fields), Delimiter, Target Table Name
i.e.
Schema: Myobfin | Country: AU | Source Table: Sales |  Source Table Key: SaleID | Source Table Address Field: ShipToAddr | Delimiter: \n | Target Table Name: SalesAddress
or for multi-field address fields
Schema: Myobfin | Country: AU | Source Table: Sales |  Source Table Key: SaleID | Source Table Address Field: ShipToAddressLine1, ShipToAddressLine2, ShipToAddressLine3, ShipToAddressLine4, ShipToAddressLine5, ShipToAddressLine6 | Delimiter: \n | Target Table Name: SalesAddress
Would that be workable for you ?
Regards,
Jason