MATLAB Answers

Import data from text file

2 views (last 30 days)
Rica
Rica on 11 Sep 2017
Edited: KL on 11 Sep 2017
Hi, i want to import data from a text file. the text is consisted of 201 column. The first column is a time column:
%
Hour:minute.second.millisecond
00:00.34.294
00:00.35.090
00:00.35.839
00:00.36.619
the oder 200 column are floting number. is textscan the approprite function to do this? Schould i specifiy the Format of all the 201 clumns, or is there any tricky function?
Thank you!

  0 Comments

Sign in to comment.

Accepted Answer

Guillaume
Guillaume on 11 Sep 2017
use readtable which should be able to figure out the format of your file on its own. It will probably fail for your time column and import it as text instead. This can be fixed either beforehand by overriding the import options or afterward with:
yourtable.yourfirstcolumn = datetime(yourtable.yourfirstcolumn, 'InputFormat', 'HH:mm.ss.S', 'Format', 'HH:mm.ss.SSS');

  1 Comment

KL
KL on 11 Sep 2017
I agree! readtable(filename) should be enough if that file is properly formatted.

Sign in to comment.

More Answers (0)