Read .txt file in matlab and save date

1 次查看(过去 30 天)
Hi! I have a file .txt with this data:
user check-in time (year-month-day hours) latitude longitude location id
0 2010-10-03 22-21-49 30.2448597206 -97.7571630478 18417
0 2010-10-02 01-48-43 30.2558143993 -97.7634179592 4256132
0 2010-10-01 14-36-39 30.2679095833 -97.7493124167 21714
0 2010-09-30 23-23-22 30.2643362697 -97.7410461251 211286
0 2010-09-29 00-31-24 30.2379105 -97.79996073 539065
0 2010-09-28 23-47-07 30.2313745667 -97.79745475 15590
0 2010-09-27 14-52-01 30.2691029532 -97.7493953705 420315
0 2010-09-26 16-43-45 30.250617981 -97.7658996582 121955
0 2010-08-30 00-11-01 30.2509939667 -97.7489662167 9508
0 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?

采纳的回答

Star Strider
Star Strider 2016-5-24
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
elisa ewin 2016-5-24
how can I selected the rows that I want?
Star Strider
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.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import and Export 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by