Need to identify count of a character appearance in a string

Hi all, I have a scenario where upstream document has a string field like below. In this string ‘:’ can appear for some records. All I need to find is how many times ‘:’ appears in the string for e...