If you are using TD 14 or higher then you can use below code snippet as reference, where column C1 will hold the intended value.
If you have strtok function then you can think of doing something like this:
select case when strtok('12/45/23/67/90/32/41/56/435/10','/',6) is not null then
You can think of using char_length, substr function too depending on your data
I have used this query as below.
sel char_length (trim(val)),
(trim (otranslate (val ,'/!@#*$%^&','')))>=6 then substr( val , 0, instr (otranslate (val ,'/!@#*$%^&','/'),'/',1,6))
else val end as res
we can use multiple symbol latters in Otranslate function for the search in a Column like REGEXP_replcae function
please fine above sql. hope it will help you.