Date: Nov 18, 2012 2:35 AM
Author: Arun Upadhayaya
Subject: Re: format for reading 'yyyymmddTHHMMSS'
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.
formatSpec = '%d-%2.2d-%2.2dT%2.2d:%2.2d:%06.3f';
but t is just printing 1998 in place of 1998-12-24T03:48:05.698
dpb <firstname.lastname@example.org> wrote in message <email@example.com>...
> 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 =
> doc sprintf % and friends for formatting