GMH Data Model Address Module

AddressTools.Module.txt

// --- AddressTools Module ---
// Module containing Lambdas for working with Addresses.

/*
 * Extract the Street from an Address
 */
AddressStreet = LAMBDA(address, LEFT(address,FIND(",",address)-1));

/*
 * Extract the City from an Adderss
 */
AddressCity = LAMBDA(address, TRIM(MID(address,FIND(",",address)+1,FIND(",",address,FIND(",",address)+1)-FIND(",",address)-1)));

/*
 * Extract the State from an Address
 */
AddressState = LAMBDA(address, TRIM(MID(address,FIND(",",address,FIND(",",address)+1)+2,2)));

/*
 * Extrct the Post Code from an Address
 */
AddressPostalCode = LAMBDA(address, RIGHT(address, 5));