How to solve readcell 1x1 missing ?

11 views (last 30 days)
I am using readcell command in order to read a file. But some numbers/data in columns show 1x1 missing. How could I solve this problem?
I ve tried
data=readcell('input.txt')
y=rmmissing(readtable(data(3:end,8)))
but no use.
Could you please help me?
  2 Comments
Walter Roberson
Walter Roberson on 21 Feb 2021
The input to readtable() has to be a character vector or scalar string object. However, data(3:end,8) would be a cell, not a character vector or string scalar. data(3:end,8) would also typically be non-scalar unless the cell just happened to have exactly 3 rows.
Ivan Mich
Ivan Mich on 21 Feb 2021
Ok , what to do then in order to separate my problem?

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 21 Feb 2021
data = readtable('input.txt', 'readvariablenames', false);
rmdata = rmmissing(data);
y = table2cell(rmdata);

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!