If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have several items that include colons (:), I need to trim out only those characters after the very last colon.
ATCC : RN-13311 : 0421 : 0421E7
Nanosphere : 8198
How would I do this with Qlik Sense?
Think you can use subfield and select the last one
SubField('ATCC : RN-13311 : 0421 : 0421E7',':',-1) returns 0421E7
View solution in original post