Removing everything after 4th "/"

[gyagos]

I've searched and i couldn't find anything relevant to what i am looking to do

i have Path information that i need to trim down so that i only see the first 4 sections after the "/"


Example of a Path within a cel
/aa/prod/bb/LCI/lib/log4j-1.2.16.jar
/aa/test/bb/phxRDS/phxRDSUAT1RuleApp/deploy.05082018/RDS_rule.ear


what i need to have displayed in a new cel
/aa/prod/bb/LCI/
/aa/test/bb/phxRDS/

Thanks in Advance

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	/aa/prod/bb/LCI/lib/log4j-1.2.16.jar	/aa/prod/bb/LCI
3	/aa/test/bb/phxRDS/phxRDSUAT1RuleApp/deploy.05082018/RDS_rule.ear	/aa/test/bb/phxRDS
Data

Cell Formulas
Range	Formula
B2:B3	B2	=TEXTBEFORE(A2,"/",5)

 

[gyagos]

How about

Fluff.xlsm
	A	B
1
2	/aa/prod/bb/LCI/lib/log4j-1.2.16.jar	/aa/prod/bb/LCI
3	/aa/test/bb/phxRDS/phxRDSUAT1RuleApp/deploy.05082018/RDS_rule.ear	/aa/test/bb/phxRDS
Data

Cell Formulas
Range	Formula
B2:B3	B2	=TEXTBEFORE(A2,"/",5)

Thanks for the quick response
i enter this formula in a new cel and i get a #NAME? error

 

[Fluff]

Ok, you obviously don't have the new functions yet, try

=REPLACE(A2,FIND("^",SUBSTITUTE(A2,"/","^",5))+1,100,"")

 

[gyagos]

Ok, you obviously don't have the new functions yet, try

=REPLACE(A2,FIND("^",SUBSTITUTE(A2,"/","^",5))+1,100,"")

Works like a charm.
Thank you very much for all your support

 

[Fluff]

You're welcome & thanks for the feedback.