Read .txt file in matlab and save date

Question

elisa ewin 2016-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285638-read-txt-file-in-matlab-and-save-date

评论： Star Strider 2016-5-24

Hi! I have a file .txt with this data:

user  check-in time (year-month-day hours) latitude            longitude       location id
2010-10-03  22-21-49       30.2448597206  -97.7571630478  18417
2010-10-02  01-48-43       30.2558143993  -97.7634179592  4256132
2010-10-01  14-36-39       30.2679095833  -97.7493124167  21714
2010-09-30  23-23-22       30.2643362697  -97.7410461251  211286
2010-09-29  00-31-24       30.2379105          -97.79996073  539065
2010-09-28  23-47-07       30.2313745667  -97.79745475  15590
2010-09-27  14-52-01       30.2691029532  -97.7493953705  420315
2010-09-26  16-43-45       30.250617981  -97.7658996582  121955
2010-08-30  00-11-01       30.2509939667  -97.7489662167  9508
2011-08-28  22-27-57       30.2448597206  -97.7571630478  18417

I want read this file in matlab and I want to save in a variable A only the rows with year 2010 and months 10 and 8, can you help me?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/285638-read-txt-file-in-matlab-and-save-date#answer_223281

在 MATLAB Online 中打开

You have to re the entire file into our workspace, then select the rows you want.

It is probably easiest to use the textscan function to read it.

For example:

fidi = fopen( ..., 'rt');
d = textscan(fidi, '%f %s %s %f %f %f', 'HeaderLines',1, 'CollectOutput',true);

The ‘d’ variable will be a cell array with the second and third columns as cell arrays of strings.

Another possibility is:

d = textscan(fidi, '%f %f-%f-%f %f-%f-%f %s %f %f %f', 'HeaderLines',1, 'CollectOutput',true);

NOTE — This is UNTESTED CODE. I do not have your file to test it with.

2 个评论
显示无隐藏无

elisa ewin 2016-5-24

how can I selected the rows that I want?

Star Strider 2016-5-24

Depending on how your read them in, use logical tests to isolate the rows for year 2010 and the months 8 and 10. Without your file to work with, I cannot be more specific.

请先登录，再进行评论。