Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi
I have a column of address - with the City in Upper case, I would like to split the string at the occurrence of Uppercase from right
Example - Uppercase i have highlighted as Red here
<tbody>
</tbody>
Thank you
I have a column of address - with the City in Upper case, I would like to split the string at the occurrence of Uppercase from right
Example - Uppercase i have highlighted as Red here
Unit 12, Wellington Fair 40 Lord Street (Entrance off Wellington Street) EAST PERTH | |
Building 3, Level B, Suites B53-B56 1 Kirinari Street BRUCE | |
Level 3 106 Edward Street BRISBANE | |
Post Split | |
Unit 12, Wellington Fair 40 Lord Street (Entrance off Wellington Street) | EAST PERTH |
Building 3, Level B, Suites B53-B56 1 Kirinari Street | BRUCE |
<tbody>
</tbody>
Thank you