Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Partner
Partner

Take specifict text

Hello dear all!

I have this column and need to take text after "-" like this:

UBERLANDIA-MG   -> MG

JOAO PESSOA-PB  -> PB

Anyone help me? Is there something like regular expression?

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: Take specifict text

3 Replies
Highlighted
Valued Contributor

Re: Take specifict text

Highlighted
Contributor III

Re: Take specifict text

Try

SubField(UBERLANDIA-MG,'-',-2)

Highlighted
Partner
Partner

Re: Take specifict text

Works. Thank you!