Measure column "file path" and retrieve text after number of "/"s to get folder name

[simondpalmer]

Hi I have a table with a column called "RevitFilePath" and I want to retrive the folder name after 4 "/" from the left till the next /.

Also omit any row that does not have this criteria. Shown below.

I have tried the following just to the text after the 4th "/" but ultimately I want to achieve as mentioned above. 

RevitFilePathOpt = 
LEFT (SEARCH("\",[RevitFilePath]), (REPT("\",4)))

Thanks in advance! 

[camargos88 · Accepted solution]

@simondpalmer ,