Function AddressMatrix

Outputs an address in a specific format for a client

AddressMatrix([MATRIX_CODE],[BREAK_STYLE],[DATATABLE],[PREFIX])

Parameters

#TypePassingDefaultNameDescription/Comments
1stringoptional100111121MATRIX_CODEThe address matrix code where:

"000111121" - this is the default without building names with no House/Flat numbers
"100111121" - this is the default with building names with no House/Flat numbers

PositionNameValues
1ADDRESS0 - The building name0 = off, 1 = on
2ADDRESS1 - The house number0 = off, 1 = on
3ADDRESS2 - The flat number0 = off, 1 = on
4ADDRESS3 - The street0 = off, 1 = on
5ADDRESS4 - The area0 = off, 1 = on
6ADDRESS5 - The town or city0 = off, 1 = on
7ADDRESS6 - The county0 = off, 1 = on
8POSTCODE - The postcode0 = off, 1 = full, 2 = partial
9CCODE - Country Code0 = off, 1 = only if not UK, 2 = always
2integeroptional0BREAK_STYLEThe break style: 0 = Comma, 1 = Space, 2 = New Line, 3 = Html Br
3stringrequiredn/aDATATABLEThe name of the data table e.g. PROPERTY or alias()
4stringrequiredn/aPREFIXAddress fields prefix. "" for normal address, For Branch "R" for registered address and "B" for bank address

Returns

The address for display


Examples

Display the full property address for the specific record

AddressMatrix("1111111111",0,"PROPERTY","")

Display the full registered address from branch

AddressMatrix("1111111111",0,"BRANCH","R")

Display the property address without building names/House number/Flat number

AddressMatrix("000111121",0,"PROPERTY","")

Display the full address for this specific record - must have address fields. This is generic and so can be used it lots of places.

AddressMatrix("1111111111",0,alias(),"")