Filter löschen
Filter löschen

Data extraction from txt with special format

1 Ansicht (letzte 30 Tage)
Win co
Win co am 1 Okt. 2014
Kommentiert: Win co am 2 Okt. 2014
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.
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

Akzeptierte Antwort

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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by