Read data from text file

2012 7 12
1 个回答
4 次查看（30 天）

0 个投票

Hi, everyone. I have .txt data file. Each new line begins with date in format mm/dd/yyyy, for example 06/25/2012. Part of the code:
A = fscanf(fid, '%g/%g/%g, ...
But dates write in 3 columns like [6 25 2012 ...]. Should I leave it or write date in one column as [06/25/2012 ... ]. The goal is to take a part of the history (for example from 6/25/2001 to 6/25/2002). What is the best way to do it?

2 个评论
显示 无 隐藏 无

Jan
Jan 2012-7-12
You forgot to mention, which format you want instead of the three columns.
Artyom
Artyom 2012-7-12
编辑：Artyom 2012-7-12
I think text string as '06/25/2012'. The only question: what is better for search?

请先登录，再进行评论。

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

回答（1 个）

Jan
Jan 2012-7-12
编辑：Jan 2012-7-12

0 个投票

Dates in three columns are fine. To convert them to serial date numbers, use datenum.
A = [6, 25, 2012];
DateNumber = datenum(A(3), A(2), A(1))

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Artyom
Artyom 2012-7-12
Oh, thanks. Maybe do you know how to take from all data a matrix from one date to another?
Jan
Jan 2012-7-12
I do not understand the question. Could you post an explicit example of the input and output?
Artyom
Artyom 2012-7-12
Ok, we have data in text file like:
02/27/2007 .....
....
02/27/2012 .....
How can I easily take data from 01/01/2009 to 01/01/2010 and put it to a new matrix.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

提问:

Artyom
Artyom
2012-7-12

Community Treasure Hunt

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

Start Hunting!

Translated by