Get specific data from text file

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 件のコメント

per isakson
per isakson 2013 年 4 月 3 日
編集済み: per isakson 2013 年 4 月 3 日
see textscan, ... '%*f' skips a column

サインインしてコメントする。

回答 (1 件)

Walter Roberson
Walter Roberson 2013 年 4 月 4 日

0 投票

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

1 件のコメント

FeiMing
FeiMing 2013 年 4 月 4 日
編集済み: FeiMing 2013 年 4 月 4 日
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.

サインインしてコメントする。

カテゴリ

ヘルプ センター および File ExchangeText Data Preparation についてさらに検索

質問済み:

2013 年 4 月 3 日

Community Treasure Hunt

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

Start Hunting!

Translated by