How to calculate a character occurance in a string in teradata

General
Enthusiast

How to calculate a character occurance in a string in teradata

Hi,

I have a column having values

1       1/2/3/4/5/6/7/8/9/10

2       1/2/3/4/5

3       1/2/3/4/5/6

4       1/2/3/4/5/6/7/8

I have to search for the character '/' and if count of the character is equal to 6 or more than 6,

then delete from 6th position of the record..

Result :

1       1/2/3/4/5/6

2       1/2/3/4/5

3       1/2/3/4/5/6

4       1/2/3/4/5/6

How can I achieve this ?

Thanks,

Jitu