0 - 2 of 2 tags for INDEX with Substring

I have a column which is a text like this-

Col = '/a/bbb/cc/aaa/ddd'

I want to output only bbb. That is everything between 2nd "/" and 3rd "/". How should I go about doing this?

Hi I am having an issue with below syntax:
When I run below query