What's new in Customer Journeys?

Connect and learn more! ×
Returning information from the middle of the value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Returning information from the middle of the value

Received Response


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):


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!