Forum Discussion
Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:-
/sites/Marketing/Budget
/sites/Marketing/Budget/2015
/sites/Marketing/Budget/206
/sites/maps
/sites/Expesnes
/sites/Expenses/2020
now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:-
/sites/Marketing/Budget
/sites/maps
/sites/Expesnes
is there any script i can run to do this cleanup?
Thanks
1 Reply
Excel formula approach.
=UNIQUE(LET(x,REGEXREPLACE(A2.:.A5000,"[0-9]",""),IF(RIGHT(x,1)="/",LEFT(x,LEN(x)-1),x)))
