Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
I have two Tables in two sheets:
Table 1 contains the list of all cities
Table 1
<tbody>
</tbody>
Table 2 Contains the Data - the string from which the City has to be separated from address
To Note: The city Name may be a single or two space ex - Mildura or Glen Iris - So space separation from right not possible
Address
<tbody>
</tbody>
Requirement - Separate City from address using city reference from table 1-city (Case insensitive to note, as data has a mix of cases)
<tbody>
</tbody>
Thank you for taking a moment to read, and further help
Table 1 contains the list of all cities
Table 1
Pakenham |
Point Cook |
Ocean Grove |
Melbourne |
Dianella |
<tbody>
</tbody>
Table 2 Contains the Data - the string from which the City has to be separated from address
To Note: The city Name may be a single or two space ex - Mildura or Glen Iris - So space separation from right not possible
Address
22 Alma Road, St Kilda |
22 Carrington Drive Pakenham |
270 Sanctuary Lakes south BVD Point Cook |
PO Box 366 Ocean Grove |
Po Box 411 Heidelberg |
PO BOX 421, Vermont |
PO Box 5134 MELBOURNE |
<tbody>
</tbody>
Requirement - Separate City from address using city reference from table 1-city (Case insensitive to note, as data has a mix of cases)
22 Alma Road | St Kilda |
22 Carrington Drive | Pakenham |
270 Sanctuary Lakes south BVD | Point Cook |
PO Box 366 | Ocean Grove |
Po Box 411 | Heidelberg |
PO BOX 421 | Vermont |
PO Box 5134 | MELBOURNE |
<tbody>
</tbody>
Thank you for taking a moment to read, and further help