dpb
Posts:
6,677
Registered:
6/7/07
|
|
Re: format for reading 'yyyymmddTHHMMSS'
Posted:
Nov 18, 2012 10:24 AM
|
|
On 11/18/2012 1:35 AM, Arun Upadhayaya wrote:
...[top posting repaired--please don't do that; hard follow conversation
makes]...
> 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 .
...
>> ... 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
...
...
> 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 de[s]cription 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
Well, first off what does header contain? Does the input work as
expected? It looks strange to me but I don't really know what you're
trying to do specifically, but...
If it is a csv file, why aren't you using 'delimiter',',' and then
skipping the fields you don't want instead of trying to parse (I guess
that's the intent of the %[^,]?).
Sotoo
fmt='%*s %*s %4d-%2d-%2dT%2d:%2d:%6f repmat('%*s,6,1) %*[^\n]';
h=textscan(fid,fmt,'delimiter',',');
--
|
|
