How to count the the specific character in a sting.

Database
-V
N/A

How to count the the specific character in a sting.

Hi All

I have table with two columns mentioned below:-

Input 
Name Item
James Alcohal:Sprit:Beer
Jon Electronics:TV
Tom Grocery:Food:Grain:Pulses
Ric Sunglass

and I need achive below output:-

Output
Name Item
James Beer
Jon TV
Tom Pulses
Ric Sunglass

Please help me out for this.

Thanks in advance for the help

-V