MATLAB Answers

0

Trouble loading in mixed data from txt file

Asked by Marissa Menzel on 29 May 2018
Latest activity Answered by Jeremy Hughes on 30 May 2018
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.

Products


Release

R2016b

2 Answers

Answer by Jeremy Hughes on 30 May 2018
 Accepted Answer

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.


Answer by 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

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);
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.