Take specifict text

[breno_morais]

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?

[vamsee · Accepted solution]

Try this

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

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/StringFunctions/SubField...

[MarioCenteno]

Try

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

[breno_morais]

Works. Thank you!