i want to read a csv file and store as rows and columns of a cell

2 次查看（过去 30 天）

显示更早的评论

Sajid Afaque 2020-6-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549006-i-want-to-read-a-csv-file-and-store-as-rows-and-columns-of-a-cell

评论： Sajid Afaque 2020-6-16

采纳的回答： Stephan

FOM_HFA_Pavg.csv

i have a csv file at a particular location. i have attached the csv file.

i want to read the data in the csv file in the below format

and the number of rows and columns are variable.(i.e i do not know how many rows and column may come)

2 个评论
显示无隐藏无

Mohammad Sami 2020-6-16

You can use the readtable function to read the data into matlab.

Sajid Afaque 2020-6-16

i tried its not giving me desired results

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephan 2020-6-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549006-i-want-to-read-a-csv-file-and-store-as-rows-and-columns-of-a-cell#answer_451857

编辑：Stephan 2020-6-16

在 MATLAB Online 中打开

fileID = fopen('FOM_HFA_Pavg.csv');
content = textscan(fileID, '%s','Delimiter','\t');
fclose(fileID);
content = content{:};
content = cellfun(@(x)strrep(x,'"',''),content,'UniformOutput',false);
idx = (cellfun('isempty',content));
content(idx) = [];
n = linecount('FOM_HFA_Pavg.csv');
content = reshape(content,[],n)'
% This function was made by Walter and should solve the problem
function n = linecount(filename)
  [fid, msg] = fopen(filename);
  if fid < 0
    error('Failed to open file "%s" because "%s"', filename, msg);
  end
    n = 0;
    while true
        t = fgetl(fid);
        if ~ischar(t)
            break;
        else
            n = n + 1;
        end
    end
    fclose(fid);
end