Splitting text into a list


I have a list of address's all as one string, each address will vary in its address text length due to house names and numbers but they will all end with "City" as in say "London City".
I want to split the original string after each "City" so cant split on "City" as it removes the trigger from the split text.
What's easiest way to do it ?


Replace all 'City' with 'City|' then split at '|'


Ha ha ha.... that was just too easy but i couldn't see it !!!!
Thank you !

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.