actually in the data it isn't necessary for the country to be preceded by 'en' which is why I was facing issues.
Is there any way to look for strings like ",us," or ",jp,"? Regex or rex expression for looking in _raw?
Sorry for the vague description of data but actually this data cannot be exposed.
They are mainly comma separated values in the middle of which we have language code,country code.
They are somewhere in the middle of _raw.