How to get the folder of an url?

Hey guys,

I wrote this this to get the folder of all the url's stored in 'founded_medicine_folder_ohne.xls' (see atachment). So far, this works. But I got the problem that this code also deletes a slash in 'https//:...' which should not be the case (after: 'https/:...'). How can I avoid that?

cellArray = readcell('founded_medicine_folder_ohne.xls');
 
folder = {};
 
for i= 1:size(cellArray,1)
    %get folder
    if ismissing(cellArray{i})
    else
        folder{i,1} = getFolderURLFromURLstring(cellArray{i});
    end
    list= cellfun(@(x) x(1:end-1), list, 'UniformOutput', false);
end
 
 writecell(folder,'founded_medicine_folder.xls') 
 
function fileName = getFolderURLFromURLstring(url)
 
        temp = strsplit(url, '/'); 
        temp(end) = '';
        fileName = strcat(strjoin(temp, '/'), '/'); 
end

Answer 1

[Johnny Cheng]

There is a easier way to get Folder URL in getFolderURLFromURLstring(url):

fileName = url(1: find(url =='/', 1,'last'))

where find() get you last index of '/' in url: https://www.mathworks.com/help/matlab/ref/find.html

[Haron Shaker]

Thank you very much, Mr. Cheng.