Get specific data from text file

2 vues (au cours des 30 derniers jours)
FeiMing
FeiMing le 3 Avr 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 commentaire
per isakson
per isakson le 3 Avr 2013
Modifié(e) : per isakson le 3 Avr 2013
see textscan, ... '%*f' skips a column

Connectez-vous pour commenter.

Réponses (1)

Walter Roberson
Walter Roberson le 4 Avr 2013
Use textscan() with HeaderLines set to 5 and format set to '%f%f%f'
  1 commentaire
FeiMing
FeiMing le 4 Avr 2013
Modifié(e) : FeiMing le 4 Avr 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.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Text Data Preparation dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by