Returning information from the middle of the value

Summary:

Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible?

Is it also possible to set null values to deliver a set value? e.g. if the Location field is blank, I'd like it to return "Homeworker".

Content (please ensure you mask any confidential information):

In the example below, I'd just want location to just return "Newcastle"

Version (include the version you are using, if applicable):

N/A

Code Snippet (add any code snippets that support your topic, if applicable):