Date: Nov 18, 2012 2:35 AM
Author: Arun Upadhayaya
Subject: Re: format for reading 'yyyymmddTHHMMSS'

Thx. Dnb,
The file i have is a csv file which has 25 description in it and reads like
1998-12-24T03:47:00.000,1998-12-24T04:08:00.000,1998-12-24T03:48:05.698, 917,54, 23.3........folowed by data.

i am reading the file by putting:
header = textscan(fid, '%[^,],%[^,],%4d-%2.2d-%2.2dT%2.2d:%2.2d:%06.3f,%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%f,%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,],%[^,\r\n]', 1);

and than writing only the 3rd decription to output.

by:
for i=3;
occtime=header{i};
end;
formatSpec = '%d-%2.2d-%2.2dT%2.2d:%2.2d:%06.3f';
fprintf(formatSpec,occtime);
but t is just printing 1998 in place of 1998-12-24T03:48:05.698

pl. comment
regards



dpb <none@non.net> wrote in message <k88i1f$4gu$1@speranza.aioe.org>...
> On 11/17/2012 10:41 AM, Arun Upadhayaya wrote:
> ...
>

> > I have to read and print as output datetime format 'yyyymmddTHHMMSS' to
> > a file. Suggest me what format i can use for the same .
> >
> > datestr converts the format but i need to just display and existing date
> > time from file 1998-12-24T03:48:05.698.

>
> I can't parse from the post precisely which form it is you have--text or
> datenum but since if it were already text it would seem your problem
> would be solved I'll presume you have a datenum something like
>

> >> dn=datenum(1998,12,24,3,48,5.698);
> >> sprintf('%4d-%2.2d-%2.2dT%2.2d:%2.2d:%06.3f',datevec(dn))

> ans =
> 1998-12-24T03:48:05.698

> >>
>
> doc sprintf % and friends for formatting
>
> --