substring in qlik sense

[124rooski]

I'm having a hard time parsing out the values from a column in qlik.

In the end, I want my values to be: Phoenix, Turkey, NYC, London, Israel, and Buenos Aires. Issue is I can do a substring for where there is a ' ' (space) but that doesn't help out Buenos Aires since that is a legitimate city with a space in the value. Left and Right functions hasn't been helpful. Am I overthinking this? Thanks.

[124rooski]

Solution:

=Replace([Training Center],'BA',  '')

[dplr-rn]

may need full data set to identify any pattern.

from your limited set if i take a pattern as 'BA ' at the start. use replace function

replace(columnname,'BA ', '') as column name

[124rooski]

Awesome, didn't see your post as our posts were 1 minute away but we both came to the same solution!