Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

To resolve issues starting MATLAB on Mac OS X 10.10 (Yosemite) visit: http://www.mathworks.com/matlabcentral/answers/159016

Get specific data from text file

Asked by FeiMing on 3 Apr 2013

I have a text file containing collected raw data. I am only interested in the three columns . How can I get only these three columns in a matrix. I tried

data= importdata('testfile.txt');

as a result I have the requested matrix data, textdata and colheaders. My question is how can I get only the data and omit the txtdata and colheaders.

There are five rows before starting collecting data.Like this, for example :

Interval=	0.001 s
ExcelDateTime=	4.1286505976192129e+004	2013-1-12 12:08:36.343
TimeFormat=	StartOfBlock
ChannelTitle=	XXXXX	XXXXX
Range=	5.000 mV	5.000 mV 

after that there are there three columns(numbers) that I want to extract them. So I do not want the upper mentioned five lines to be included.

1 Comment

per isakson on 3 Apr 2013

see textscan, ... '%*f' skips a column

FeiMing

Products

No products are associated with this question.

1 Answer

Answer by Walter Roberson on 4 Apr 2013

Use textscan() with HeaderLines set to 5 and format set to '%f%f%f'

1 Comment

FeiMing on 4 Apr 2013

fid= fopen('TestFile.txt');

C= textscan(fid,'%f%f%f', 'HeaderLines',5);

it gives C<1x3 cell> every element contains 40256x1 double

but no data/numbers, 40256 reflects the number of sampled data in every column.

Walter Roberson

Contact us