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

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)

[Mohammad Sami]

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

[Sajid Afaque]

i tried its not giving me desired results

Answer 1

[Stephan]

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

[Sajid Afaque]

here i see in last line you have done

 numel(content)/2

which holds good if i have only 2 rows .

but i will have more than 2 rows (i.e variable number of rows and columns)

[Stephan]

See my edited answer - i found a little helper function, written by Walter, that counts the lines of a .txt-file, so that it ist clear how many rows are needed for your purpose dynamically.

https://de.mathworks.com/matlabcentral/answers/81137-pre-determining-the-number-of-lines-in-a-text-file#answer_250008

[Sajid Afaque]

no actually i keep appending data.

i tried using readtable to know how many columns i have in first row but problem what i faced their was(i have one extra column at last filled by NaN and what i also fear is how will it behave if any of the row contains empty column)

[Stephan]

i edited my previous comment - i think its solved now.

[Sajid Afaque]

thank you @stephan and @Walter