Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
breno_morais
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?

1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

3 Replies
vamsee
Specialist
Specialist

MarioCenteno
Creator III
Creator III

Try

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

breno_morais
Partner
Partner
Author

Works. Thank you!