I am trying to extract a specific value from the column which has the value as path. The value looks like below
//prod/check/error/Jan/Afolder/a_20221023.csv
//prod/check/error/Jan/Bfolder/c_20221023.csv
From the above values I want to extract only values as
Afolder
Bfolder
I have tried with reverse and charindex functions. But not able to get desired results.
