MATLAB: Retrieve data containing date and time from text file


Hi all,
I encountered the following strange problem when trying to retrieve date and time and other data from a text string.
The following runs OK.
>>tmp = '460018898104779 6d0502fb0be52d 2018-09-27 23:59:48';
>>test2 = textscan(tmp, '%f%14c%{yyyy-MM-dd HH:mm:ss}D', 'Delimiter',{'\n'});
But when I append two more doubles to the text string and run
>>tmp = '460018898104779 6d0502fb0be52d 2018-09-27 23:59:48 113.944081 22.504949';
>>test2 = textscan(tmp, '%f%14c%{yyyy-MM-dd HH:mm:ss}D%f%f', 'Delimiter',{'\n'});
It gives the following error message:
>>Error using textscan
>>Unable to read the DATETIME data with the format 'yyyy-MM-dd HH:mm:ss'. If the data is not a time, use %q to get text data.
Could somebody help to clarify what has gone wrong? Thank you very much!

Best Answer

You should use Delimiter '\t' rather than \n