Data extraction from txt with special format

Question

Win co 2014-10-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/156974-data-extraction-from-txt-with-special-format

评论： Win co 2014-10-2

Hello,

Given a following .txt file with 5 columns delimited by tab, I have difficulty at extracting these data in a matrix (double) where the 3rd column contains converted values in seconds.

   ID DDD HH:MM:SS.mmmuuun      PARA1      PARA2
    1   0 01:05:04.9941480     0.0131     0.0000

In this example, in my matrix, the 3rd column has to be 1*3600+5*60+4.9941480. Could anyone help me to solve it please? Best regards, Winn

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2014-10-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/156974-data-extraction-from-txt-with-special-format#answer_153520

在 MATLAB Online 中打开

Try the readtable() function:

t = readtable(fullFileName);

If that doesn't work, try textscan().

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Win co 2014-10-2

Thanks for your recommendation. I'm using Maltab2012b, "readtable" function does not exist. I've figured out how to solve this problem with textscan, maybe not optimal but it works as I wish. In sum, I seperate numeric data and string data. With the last one, I convert to numeric value.

请先登录，再进行评论。