How to rearrange xml elements,extract relevant data from the values

Question

abbelylee 0 Newbie Poster

11 Years Ago

I am trying to extract specific values of element from xml document and produce an output of XML data or a CSV document and arrange them is this order.
Locator designator
Locator name
Locator
Thoroughfare
Addressarea.

current order:

<Locator>1</Locator>
      <LocatorDesignator>Dwelling  (Part Of), Null</LocatorDesignator>
      <thoroughfare>Abesinia Passage</thoroughfare>
      <AddressArea>Abesinia Passage</AddressArea>
      <LocatorName>Dwelling  (Part Of)</LocatorName>

I know <xsl:value-of> is used in extracting values of element but I’m unsure of how to extract specific values from an element with it.
My intensions are to extract to output any data in <AddressArea>the has suffix of Estate,Bay,Barrack,Island,Village(am thinking i could just type them out e.g LAguna estate or there is a magical way XSLT can do it?)

Also, delete any data in <thoroughfare> with NULL value or with suffix that end with Estate,Bay,Barrack,Island,Village and produce an output of the remainin data.

in the <LocatorName> i want to extract any data with the suffix ofHome,House,Square,building, road,park,aleos. if i can get the idea of how to do these extraction i would be able to apply them to the rest of the data.

i have attached the an XML file of the data and its representation in CSV. i also attached a CSV representation of the output.

<Address>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Dwelling  (Part Of), Null</LocatorDesignator>
<thoroughfare>Abesinia Passage</thoroughfare>
<AddressArea>Abesinia Passage</AddressArea>
<LocatorName>Dwelling  (Part Of)</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1a</Locator>
<LocatorDesignator>Edmund's Home, Null</LocatorDesignator>
<thoroughfare>Arena's Palace Lane</thoroughfare>
<AddressArea>Arena's Palace Lane</AddressArea>
<LocatorName>Edmund's Home</LocatorName>
</Rowinfo>


<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Armstrange's Steps</thoroughfare>
<AddressArea>Armstrange's Steps</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 3</LocatorDesignator>
<thoroughfare>Armstrange's Steps</thoroughfare>
<AddressArea>Armstrange's Steps</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 5</LocatorDesignator>
<thoroughfare>Armstrange's Steps</thoroughfare>
<AddressArea>Armstrange's Steps</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 2</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 3</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 4</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 5</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 6</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 6a</LocatorDesignator>
<thoroughfare>Bala's Passage</thoroughfare>
<AddressArea>Bala's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1a</Locator>
<LocatorDesignator>Shop, Null</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 2</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 3</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 4</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 5</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 6</LocatorDesignator>
<thoroughfare>Bakery's Passage</thoroughfare>
<AddressArea>Bakery's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>2a</Locator>
<LocatorDesignator>Flat, Null</LocatorDesignator>
<thoroughfare>Benodiel's Passage</thoroughfare>
<AddressArea>Benodiel's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, Null</LocatorDesignator>
<thoroughfare>Benodiel's Passage</thoroughfare>
<AddressArea>Benodiel's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>7a</Locator>
<LocatorDesignator>Shop, Null</LocatorDesignator>
<thoroughfare>Bishop Rapallo Camp</thoroughfare>
<AddressArea>Bishop Rapallo Camp</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Dwelling, Null</LocatorDesignator>
<thoroughfare>Boschekis Steps</thoroughfare>
<AddressArea>Boschekis Steps</AddressArea>
<LocatorName>Dwelling</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 1</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 2</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 3</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 4</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 5</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 6</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 7</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 8</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 9</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  - Buena Villa House, 10</LocatorDesignator>
<thoroughfare>Buena Villa Road</thoroughfare>
<AddressArea>Buena Villa Road</AddressArea>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  1   Anderson's House, 1</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat  1   Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  2   Anderson's House, 2</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat  2   Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  3   Anderson's House, 3</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat  3   Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  3a  Anderson's House, 03a</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat  3a  Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do    4          Do, 4</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do    4          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do    5          Do, 5</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do    5          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do    6          Do, 6</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do    6          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do    7          Do, 7</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do    7          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat  8  `Anderson's House', 8</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat  8  `Anderson's House'</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do    9          Do, 9</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do    9          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   10          Do, 10</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   10          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   11          Do, 11</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   11          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop And Store, 12</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Shop And Store</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 13  `Anderson's House', 13</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat 13  `Anderson's House'</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   14          Do, 14</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   14          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   15          Do, 15</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   15          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   16          Do, 16</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   16          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   17          Do, 17</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   17          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   18          Do, 18</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   18          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   19          Do, 19</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   19          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   20          Do, 20</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   20          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   21          Do, 21</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   21          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 22          Do, 22</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat 22          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   23          Do, 23</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   23          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   24          Do, 24</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   24          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   25          Do, 25</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   25          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   26          Do, 26</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   26          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   27          Do, 27</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   27          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   28          Do, 28</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   28          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   29          Do, 29</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   29          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   31          Do, 31</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   31          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   32          Do, 32</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   32          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   33          Do, 33</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   33          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   34          Do, 34</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   34          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 35          Do, 35</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat 35          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   36          Do, 36</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   36          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Do   37          Do, 37</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Do   37          Do</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 38   Anderson's House, 38</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Flat 38   Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garden, a</LocatorDesignator>
<thoroughfare>Calpet Road</thoroughfare>
<AddressArea>Calpet Road</AddressArea>
<LocatorName>Garden</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Store, a</LocatorDesignator>
<thoroughfare>Carrena's Passage</thoroughfare>
<AddressArea>Carrena's Passage</AddressArea>
<LocatorName>Store</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Store, b</LocatorDesignator>
<thoroughfare>Carrera's Passage</thoroughfare>
<AddressArea>Carrera's Passage</AddressArea>
<LocatorName>Store</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Shop, 01-Feb</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>"Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant/Cafe Bar &amp; Stores J-K, 3</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant/Cafe Bar &amp; Stores J-K</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant/Bar  &amp; Store L, 4</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant/Bar  &amp; Store L</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant/Cafe &amp; Store M, 5</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant/Cafe &amp; Store M</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06C</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06D</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06E</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 06F</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07C</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07D</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07E</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 07F</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant/Bar  &amp; Store N, 8</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant/Bar  &amp; Store N</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant      &amp; Store O, 9</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant      &amp; Store O</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Bar/Brasserie   &amp; Store P, 10</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Bar/Brasserie   &amp; Store P</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Restaurant/Cafeteria &amp; Store Q, 11</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Restaurant/Cafeteria &amp; Store Q</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Restaurant, 12</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>"Restaurant</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Store, 13A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Store</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 13B/14B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 14A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 15A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 15B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 16A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 16B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 17A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Office, 17B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Office</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 18A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 18B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 19A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 19B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 20A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 20B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 21A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Part Of Restaurant, 21B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Part Of Restaurant</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 22A</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, 22B</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Exhibition Gallery, 23-25</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Exhibition Gallery</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Stores R-S, R-S</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Stores R-S</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Gas Cylinder Store T, T</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Gas Cylinder Store T</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Caretaker's Office Etc, V</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Caretaker's Office Etc</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, W</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Cafeteria / Snack Bar Etc, Y-Z</LocatorDesignator>
<thoroughfare>Casenapes Square</thoroughfare>
<AddressArea>Casenapes Square</AddressArea>
<LocatorName>Cafeteria / Snack Bar Etc</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>2a</Locator>
<LocatorDesignator>Dwelling, Null</LocatorDesignator>
<thoroughfare>Castleden Steps</thoroughfare>
<AddressArea>Castleden Steps</AddressArea>
<LocatorName>Dwelling</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Dwelling, Null</LocatorDesignator>
<thoroughfare>Castleden Steps</thoroughfare>
<AddressArea>Castleden Steps</AddressArea>
<LocatorName>Dwelling</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Office  Store &amp; Plot Of Land, Null</LocatorDesignator>
<thoroughfare>Catadan Bay Road</thoroughfare>
<AddressArea>Catadan Bay Road</AddressArea>
<LocatorName>Office  Store &amp; Plot Of Land</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1a</Locator>
<LocatorDesignator>C.P.S. (5 In No.), Null</LocatorDesignator>
<thoroughfare>Central Pavilion Road</thoroughfare>
<AddressArea>Central Pavilion Road</AddressArea>
<LocatorName>C.P.S. (5 In No.)</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Maisonette Garage Etc - The Elms, Null</LocatorDesignator>
<thoroughfare>Central Pavilion Road</thoroughfare>
<AddressArea>Central Pavilion Road</AddressArea>
<LocatorName>Maisonette Garage Etc - The Elms</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>6a</Locator>
<LocatorDesignator>Flat, Null</LocatorDesignator>
<thoroughfare>Chibardo's Passage</thoroughfare>
<AddressArea>Chibardo's Passage</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices, Null</LocatorDesignator>
<thoroughfare>College Lane</thoroughfare>
<AddressArea>College Lane</AddressArea>
<LocatorName>Offices</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1a</Locator>
<LocatorDesignator>Shop &amp; Tearoom, Null</LocatorDesignator>
<thoroughfare>Convental Place</thoroughfare>
<AddressArea>Convental Place</AddressArea>
<LocatorName>Shop &amp; Tearoom</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, Null</LocatorDesignator>
<thoroughfare>Cornmill's Lane</thoroughfare>
<AddressArea>Cornmill's Lane</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, Null</LocatorDesignator>
<thoroughfare>Cornmill's Parade</thoroughfare>
<AddressArea>Cornmill's Parade</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Bank, Null</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>"Bank</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2a       Funlife Building, 02a</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2a       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2b       Funlife Building, 02b</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2b       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2c       Funlife Building, 02c</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2c       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2d       Funlife Building, 02d</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2d       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2e       Funlife Building, 02e</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2e       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Offices Unit 2f, 02f</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>"Offices Unit 2f</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 2g       Funlife Building, 02g</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 2g       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3a       Funlife Building, 03a</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3a       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3b       Funlife Building, 03b</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3b       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Offices Unit 3c, 03c</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>"Offices Unit 3c</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3d       Funlife Building, 03d</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3d       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3e       Funlife Building, 03e</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3e       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3f       Funlife Building, 03f</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3f       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3g1      Funlife Building, 03g1</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3g1      Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 3g2      Funlife Building, 03g2</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 3g2      Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 4a       Funlife Building, 04a</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 4a       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 4b       Funlife Building, 04b</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 4b       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Offices Unit 4c       Funlife Building, 04c</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Offices Unit 4c       Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>"Bank Units 4d-4g, 04d/g</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>"Bank Units 4d-4g</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Pent House            Funlife Building, a</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Pent House            Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Car Parking Spaces    Funlife Building, b</LocatorDesignator>
<thoroughfare>Corporal Road</thoroughfare>
<AddressArea>Corporal Road</AddressArea>
<LocatorName>Car Parking Spaces    Funlife Building</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, Null</LocatorDesignator>
<thoroughfare>Crutchetty's Ramp</thoroughfare>
<AddressArea>Crutchetty's Ramp</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Store, Null</LocatorDesignator>
<thoroughfare>Cumberlane Road</thoroughfare>
<AddressArea>Cumberlane Road</AddressArea>
<LocatorName>Store</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop, a</LocatorDesignator>
<thoroughfare>Cumberlane Road</thoroughfare>
<AddressArea>Cumberlane Road</AddressArea>
<LocatorName>Shop</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Cumberlane Steps</thoroughfare>
<AddressArea>Cumberlane Steps</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 2</LocatorDesignator>
<thoroughfare>Cumberlane Steps</thoroughfare>
<AddressArea>Cumberlane Steps</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Danial's Ramp</thoroughfare>
<AddressArea>Danial's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 2</LocatorDesignator>
<thoroughfare>Danial's Ramp</thoroughfare>
<AddressArea>Danial's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 3</LocatorDesignator>
<thoroughfare>Danial's Ramp</thoroughfare>
<AddressArea>Danial's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 4</LocatorDesignator>
<thoroughfare>Danial's Ramp</thoroughfare>
<AddressArea>Danial's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>10a</Locator>
<LocatorDesignator>Plot Of Land, Null</LocatorDesignator>
<thoroughfare>Demayania's Ramp</thoroughfare>
<AddressArea>Demayania's Ramp</AddressArea>
<LocatorName>Plot Of Land</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 1</LocatorDesignator>
<thoroughfare>Demayania's Ramp</thoroughfare>
<AddressArea>Demayania's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 2</LocatorDesignator>
<thoroughfare>Demayania's Ramp</thoroughfare>
<AddressArea>Demayania's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 3</LocatorDesignator>
<thoroughfare>Demayania's Ramp</thoroughfare>
<AddressArea>Demayania's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat, 4</LocatorDesignator>
<thoroughfare>Demayania's Ramp</thoroughfare>
<AddressArea>Demayania's Ramp</AddressArea>
<LocatorName>Flat</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop 1         Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Shop 1         Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop 2-3       Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Shop 2-3       Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Shop 4         Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Shop 4         Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  1    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  1    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  2    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  2    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  3    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  3    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  4    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  4    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  5    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  5    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  6    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  6    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  7    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  7    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  8    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  8    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop  9    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop  9    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 10    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 10    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 11    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 11    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 12    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 12    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 13    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 13    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 14    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 14    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 15    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 15    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 16    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 16    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 17    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 17    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 18    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 18    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 19    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 19    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 20    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 20    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 21    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 21    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 22    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 22    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 23    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 23    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 24    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 24    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 25    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 25    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 26    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 26    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Workshop 27    Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Workshop 27    Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Plot Of Land      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Plot Of Land      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 1         Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Flat 1         Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 2         Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Flat 2         Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Flat 3         Elton House, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Flat 3         Elton House</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  1      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  1      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  2      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  2      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  3      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  3      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  4      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  4      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  5      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  5      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  6      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  6      Elton Park</LocatorName>
</Rowinfo>
<Rowinfo>
<Locator>1</Locator>
<LocatorDesignator>Garage  7      Elton Park, Null</LocatorDesignator>
<thoroughfare>Devil's Road</thoroughfare>
<AddressArea>Devil's Road</AddressArea>
<LocatorName>Garage  7      Elton Park</LocatorName>
</Rowinfo

xml

2 Contributors
8 Replies
206 Views
3 Days Discussion Span
Latest Post 11 Years Ago Latest Post by Mike Askew

All 8 Replies

Mike Askew 131 Veteran Poster

11 Years Ago

So what actually remains to be done? As you've solved some of your own problems fine :)

You dont need to change anything about the element re-ordering XSL thats how I would of done it.

Mike Askew 131 Veteran Poster

11 Years Ago

Not entirely sure how to do that myself, obviously its substrings, however your trying to delete strings that could be any length and position, not sure how you pin it down in terms of XSLT.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

abbelylee 0 Newbie Poster · Answer 1 · 2012-08-21T13:52:33+00:00

i made another .xsl to rearrange it using this

    <xsl:output indent="yes" method="xml"/> 
    <xsl:template match="/">

        <Address>  <xsl:apply-templates/> </Address>
    </xsl:template>

    <xsl:template match="Address/Rowinfo ">

         <xsl:copy>
            <xsl:copy-of select="LocatorDesignator"/>
            <xsl:copy-of select="LocatorName"/>
            <xsl:copy-of select="Locator"/>
             <xsl:copy-of select="thoroughfare"/>
            <xsl:copy-of select="AddressArea"/>
        </xsl:copy>
        </xsl:template>

</xsl:stylesheet>

Is there another way it can be done? this is as a result of the ouput of the first question

abbelylee 0 Newbie Poster · Answer 2 · 2012-08-23T14:40:31+00:00

i used these code to take care of the thoroghfare and the addressares

<xsl:stylesheet version="1.0"
        xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
        <xsl:output omit-xml-declaration="yes" indent="yes"/>
        <xsl:strip-space elements="*"/>

        <xsl:template match="node()|@*">
            <xsl:copy>
                <xsl:apply-templates select="node()|@*"/>
            </xsl:copy>
        </xsl:template>

    <xsl:template match= "AddressArea/text()
        [substring(., string-length() -5) != 'island'
        and
        substring(., string-length() -5) != 'Estate'
        ]"/>

    <xsl:template match=
        "thoroughfare/text()
        [substring(., string-length() -5) = 'Estate']"/>

which deleted the text node in AddressArea that doesn't end with "island" and extracted the value that ends with estate in the thoroughfare.

abbelylee 0 Newbie Poster · Answer 3 · 2012-08-23T15:44:40+00:00

i want to manipulate and edit the following data with xslt

Address>
<Rowinfo>
<LocatorDesignator>Dwelling  (Part Of) Null</LocatorDesignator>
<LocatorName>Flat  - Buena Villa House</LocatorName>
</Rowinfo>
<Rowinfo>
<LocatorDesignator>Flat  - Buena Villa House 1</LocatorDesignator>
<LocatorName>Flat  3a  Anderson's House</LocatorName>
</Rowinfo>
<Rowinfo>
<LocatorDesignator>Offices Unit 2a Funlife Building 02a</LocatorDesignator>
<LocatorName>office Unit 2a   Funlife Building  <LocatorName>
 </Rowinfo>
 </Address>

to produce this

<LocatorDesignator>Dwelling(Part Of)</LocatorDesignator>
<LocatorName>Buena Villa House</LocatorName>

<LocatorDesignator>Flat 1</LocatorDesignator>
<LocatorName> Anderson's House</LocatorName>

<LocatorDesignator>office Unit 2a</LocatorDesignator>
<LocatorName> Funlife Building  <LocatorName>

In both elements all NULL values should be deleted if found. locator name:any value with the suffix HOUSE,BUILDING is extracted to the output. for example "Flat - Buena Villa House" when "Buena Villa House" is extracted it should produce "Buena Villa House" or in "office Unit 2a Funlife Building " when "Funlife Building" is extracted it produces "Funlife Building"

Locator designator: any suffix with HOUSE,BUILDING is deleted including dublicate values for example "Offices Unit 2a Funlife Building 02a" when "Funlife Building" is deleted we will have "Offices Unit 2a 02a" a further deletion to remove "02a" should produce this "Offices Unit 2a" in the case of "Flat - Buena Villa House 1" when "Buena Villa House" is deleted we should have this "Flat - 1" . if there is a way to remove the "-" aswell to give "Flat1"

abbelylee 0 Newbie Poster · Answer 4 · 2012-08-23T22:23:40+00:00

abbelylee 0 Newbie Poster

11 Years Ago

the last question i posted is what is left.

abbelylee 0 Newbie Poster · Answer 5 · 2012-08-24T16:51:33+00:00

is it possible to delete some specific string, for instance
"Flat - Buena Villa House 1" to delete "Buena Villa House" from the string?

Mike Askew 131 Veteran Poster Featured Poster · Answer 6 · 2012-08-25T11:28:31+00:00

Could use the replace function

fn:replace(string,pattern,replace) Returns a string that is created by replacing the given pattern with the replace argument

ie. replace(YourNodeString, "Buena Villa House", "")

try that for deletion

How to rearrange xml elements,extract relevant data from the values

Recommended Answers Collapse Answers

All 8 Replies

Recommended Answers