Trim an Item name that contains :

[jaymeknapp]

I have several items that include colons (:), I need to trim out only those characters after the very last colon. 

i.e.   

ATCC : RN-13311 : 0421 : 0421E7

Nanosphere : 8198

How would I do this with Qlik Sense?

[dplr-rn · Accepted solution]

Think you can use subfield and select the last one

e.g.

SubField('ATCC : RN-13311 : 0421 : 0421E7',':',-1) returns 0421E7