how to read mixed date and data

How to read this data file:

2020/11/15 07:30:55 27.50 124

2020/11/15 07:40:55 27.63 114

2020/11/15 07:50:55 27.71 95

Answer 1

[Jeremy Hughes]

I made some corrections in the comments above, but this is how I would do this more robustly using partial detection with detectImportOptions.

filename = "example.txt";
opts = detectImportOptions(filename,"Delimiter","\t");
opts = setvaropts(opts,1,"Type","datetime","InputFormat","uuuu/MM/dd HH:mm:ss");
T = readtable(filename,opts)

T = 3×3 table
           Var1            Var2     Var3
    ___________________    _____    ____

    2020/11/15 07:30:55     27.5    124 
    2020/11/15 07:40:55    27.63    114 
    2020/11/15 07:50:55    27.71     95 

[DwiNY]

Dear Jeremy Hughes,

Thank you very much

DwiNY

[DwiNY]

Jeremy,

If you could make more a general, i.e. input file with XX number of lines of header would be appreciate.

Thank you

Answer 2

[the cyclist]

I would try the readtable function.

You can specify the input formating if needed.

[DwiNY]

Here what I did,

formatSpec = '%{yyyy/mm/DD hh:mm:ss}D%f%d';

T = readtable('AirTemp_20893260.txt','Delimiter','\t', ...

'Format',formatSpec);

aa=T.Var2;

------------

Var2 and Var3 are ok, however, var1 somehow some of them NAT

[the cyclist]

NaT means "Not-aTime", and you will typically get this error if some of the times are a different format from what you have specified.

Can you upload the data, or a small sample that has some rows that worked, and some rows that gave NaT?

[DwiNY]

Finally, I able to read the file correctly:

fid=fopen('filename.txt','rt');

formatSpec = '%{yyyy/mm/dd}D %{HH:mm:ss}D %f%f ';

delimiter = {'\t',' '};

dataArray = textscan(fid, formatSpec, 'Delimiter', delimiter,'MultipleDelimsAsOne', true, 'ReturnOnError', false);

fclose(fid)

[Jeremy Hughes]

If you're using format, there are issues with your format in both cases: mm cannot be both months and minutes, you want MM.

Also, you probably want the second part as duration if you're parsing these as separate fields.

try this: formatSpec = '%{yyyy/MM/dd}D{hh:mm:ss}T%f%f'

But I like your first approach better:

delimiter = '\t'; %no space

formatSpec = '%{yyyy/MM/dd HH:mm:ss}D%f%f'