MATLAB Answers

Trouble loading in mixed data from txt file

2 views (last 30 days)
I'm trying to load in data from a text file. The first two rows are headers, following the headers the first two columns are date and time. The rest of the columns are floats.
data should have 11 columns, however, whos returns that size is only 1x3
fid = fopen('allunderway.txt', 'rt');
data = textscan(fid, '%{M/dd/yyyy}D %{HH:mm:ss}D %4.2f %2.4f %2.5f %2.4f %2.4f %2.2f %4.2f %3.1f %1.4f', 'HeaderLines', 2, 'CollectOutput', true);
fclose(fid);
whos data
date = data{1};
time = data{2};
wnd_td = data{10};
wnd_ts = data{11};

  0 Comments

Sign in to comment.

Accepted Answer

Jeremy Hughes
Jeremy Hughes on 30 May 2018
You're adding 'CollectOutput' which is concatenating all the numeric columns into one. If you remove that, you should get the number of columns you expect.

  0 Comments

Sign in to comment.

More Answers (1)

KSSV
KSSV on 30 May 2018
Try this:
fid = fopen('allunderway.txt', 'rt');
data = textscan(fid, '%{M/dd/yyyy}D %{HH:mm:ss}D %4.2f %2.4f %2.5f %2.4f %2.4f %2.2f %4.2f %3.1f %1.4f', 'HeaderLines', 2, 'Delimiter','\n', 'CollectOutput', true);
fclose(fid);
whos data
date = data{1};
time = data{2};

  2 Comments

Marissa Menzel
Marissa Menzel on 30 May 2018
I tried your version and got an error message for the dates.
Error using textscan Unable to read the DATETIME data with the format 'M/dd/yyyy'. If the data is not a time, use %q to get text data.
Error in windconversions (line 21) data = textscan(fid, '%{M/dd/yyyy}D %{HH:mm:ss}D %4.2f %2.4f %2.5f %2.4f %2.4f %2.2f %4.2f %3.1f %1.4f', 'HeaderLines', 2, 'Delimiter','\n', 'CollectOutput', true);
Marissa Menzel
Marissa Menzel on 30 May 2018
I tried changing both to %q as recommended and the error went away but the matrix dimensions for data were still only 1x2

Sign in to comment.

Sign in to answer this question.

Products


Release

R2016b