Splitting text into a list

Hi,

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 ?

Cheers
Steve

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

2 Likes

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.