清空筛选条件
清空筛选条件

problem in importing data through textscan

1 次查看（过去 30 天）
Md. Moklesur Rahman
Hello everybody,
In fact, I have a text file with dat extension in which the data format is as follows:
Date Time CO
2009-02-25 18:39:01 165.3
I used the following code to import the data:
fid = fopen('CO_2009_m.dat','r');
data_f2 = textscan(fid,'%s %s %f', 'delimiter', ' ', 'collectoutput',1,'headerlines',1);
fclose(fid)
and I found where my CO concentration is two digits before decimal, for instance, 70.1, the output is as follows:
357.9
357.2
NaN
NaN
359.4
and even sometimes the data is mixed with the string as follows:
'2009-01-02' '19:30:00'
'4.6' ''
2009-01-02' '19:40:00'
'2009-01-02' '19:50:00'
'0.5' ''
Does any body have any idea how can I get rid of this situation importing the string and the data separately?
kind regards,
Rahman
  1 个评论
per isakson
per isakson 2012-8-22
Are you sure it is space delimited? Try and remove the spaces from the format specifier.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

per isakson
per isakson 2012-8-22
编辑：per isakson 2012-8-22
Try this
fid = fopen('cssm.txt', 'r' );
data_f2 = textscan( fid,'%s%s%f' ...
, 'delimiter' , ' ' ...
, 'headerlines' , 1 ...
, 'MultipleDelimsAsOne' , true ...
, 'CollectOutput' , true );
fclose(fid)
.
and this
fid = fopen('cssm.txt', 'r' );
data_f2 = textscan( fid,'%s%s%f' ...
... , 'delimiter' , ' ' ...
, 'headerlines' , 1 ...
... , 'MultipleDelimsAsOne' , true ...
, 'CollectOutput' , true ...
);
fclose(fid)
.
Tested with R2012a, 64bit, Windows7.
Default for Delimiter is "white-space", which includes space, tab, etc.
Doc says: "... If you do not specify a delimiter, textscan interprets repeated white-space characters as a single delimiter."

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by