How can I get the last value of indent seperated field

[Anonymous]

Hi Qlik Community,

I want to split a field. I have the following data set:

taxonomy

coffee machine-steel case-manual

tea machine-cup warmer-steel case-automatic

coffee/tea machine-one touch-cup warmer-automatic

How can I get the last value (type of the machine) of the field?

taxonomy	machine type
coffee machine-steel case-manual	manual
tea machine-cup warmer-steel case-automatic	automatic
coffee/tea machine-one touch-cup warmer-automatic	automatic

I have try it with the function 'SubField':

SubField(taxonomy, '-' ,?)

? Is there a function as index for the last value, because my separate field has different number of parts.

Have you an idea what can I do or an alternative way to resolve my problem?

Thanks,

Gamze

[m_woolf · Accepted solution]

Try -1

[Anonymous]

Thanks