Data extraction from txt with special format

2 次查看（过去 30 天）
Win co
Win co 2014-10-1
评论： 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

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

采纳的回答

Image Analyst
Image Analyst 2014-10-1
Try the readtable() function:
t = readtable(fullFileName);
If that doesn't work, try textscan().
  1 个评论
Win co
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by