reading a .txt file with dates

ALEKSANDER — Sun, 03 Aug 2008 18:05:04 -0400

Hi!

I've got a file in this form:
dd/mm/yy [integer]

The first lines of my file (result.txt):
30/07/08 161
31/07/08 150
01/08/08 151
05/08/08 160

And I wish to generate two vectors: x(n) with n as the n'th
line in the file, with the dates in the form "datenum", and
the other offcourse y(n) with the corresponding numbers.

to make it all crystall clear:
x(1) = datenum(20/07/08) %this is wrong,but u get the idea!
y(1) = 161
...etc

If the format of the file is difficult to read, I can
easily change it, it's matlab-genrated.

Thanks!
Aleksander, Norway

reading a .txt file with dates

Andres — Sun, 03 Aug 2008 19:52:01 -0400

"ALEKSANDER " <aleksander.rise.gallala@gmail.com> wrote in
message <g74s0g$j2h$1@fred.mathworks.com>...
> Hi!
>
> I've got a file in this form:
> dd/mm/yy [integer]
>
> The first lines of my file (result.txt):
> 30/07/08 161
> 31/07/08 150
> 01/08/08 151
> 05/08/08 160
>
> And I wish to generate two vectors: x(n) with n as the n'th
> line in the file, with the dates in the form "datenum", and
> the other offcourse y(n) with the corresponding numbers.
>
> to make it all crystall clear:
> x(1) = datenum(20/07/08) %this is wrong,but u get the idea!
> y(1) = 161
> ...etc
>
> If the format of the file is difficult to read, I can
> easily change it, it's matlab-genrated.
>
> Thanks!
> Aleksander, Norway

The file format is easy to read, by humans and by matlab :-)
Obviously, get the plain numbers first, e.g. using textscan
(you only need to tell textscan that '/' should be treated
as a whitespace - look for the 'Whitespace' parameter in the
doc), and then feed datenum with the properly arranged
numbers, x = datenum(Y, M, D)
regards
Andres

MATLAB Central Newsreader - reading a .txt file with dates

reading a .txt file with dates

reading a .txt file with dates