Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
jaymeknapp
Contributor II
Contributor II

Trim an Item name that contains :

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?

Labels (1)
  • trim

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Think you can use subfield and select the last one

e.g.

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

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

Think you can use subfield and select the last one

e.g.

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