Remove characters before :

[qlikwiz123]

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 ':'

[BrunPierre · Accepted solution]

Trim(SubField(Field,':',-1))

[qlikwiz123]

Perfect, thank you!

[qlikwiz123]

@BrunPierre  What if I only want to remove the string before the 1st two ':' and not check for more than two ':'?

[BrunPierre]

And what would that output be?

[qlikwiz123]

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

In this case, the column has more than two ':'. The output should be 

Div2: Please change the report

[BrunPierre]

This will work in both instances.

TextBetween(Mid(Field,Index(Field,'Agent')),': ','')

[qlikwiz123]

Sorry. My Bad. Maybe my question wasn't clear.

Original Value:

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

In this case, the column has more than two ':'. The output should be

Output: 

Div2: Please change the report

The output should only eliminate text/characters before the first two ':' occurrences and ignore from the third.

[BrunPierre]

Have you tried this yet?

TextBetween(Mid(Field,Index(Field,'Agent')),': ','')

---

[MarcoWedel · Accepted solution]

Mid(Data, Index(Data, ':', 2)+1)