Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Remove characters before :

I have Column - Data that has values in the format below

 

10/25/2015 : Agent1: This is the right value

05/11/2017 : Agent 56: Please change the report

I need to remove everything before the second ':' and only show the text in my output.

This is the right value
Please change the report

 

How do I do this in the expression or Script? I tried =Mid(Data, Index(Data, ': ')+2) but this only removes text before the first ':'

Labels (2)
10 Replies
qlikwiz123
Creator III
Creator III
Author

This is more dynamic since I don't have to mention the string 'Agent' as this is not constant. Thank you