ignore some data in file
显示 更早的评论
hi,
this is sample of data in file, what I need is ignoring the rows with marks ** in file, how do that?
1800254325 Othello (1995) 26
1800246889 Now and Then (1995) 27
1800246848 Persuasion (1995/I) 28
********Cité des enfants perdus, La (1995) 29
1800024450 Shanghai Triad (Yao a yao yao dao waipo qiao) (1995) 30
1800242776 Dangerous Minds (1995) 31
********Twelve Monkeys (1995) 32
1800026894 Wings of Courage (1995) 33
1800020413 Babe (1995) 34
1800249202 Carrington (1995) 35
thanks
2 个评论
Jan
2011-10-11
Please format you text again. Start lines with a space to prevent the automatic joining of lines.
huda nawaf
2011-10-11
回答（2 个）
Kevin
2011-10-11
It isn't too elegant, but the way I would approach it is to first read in all of the text data using a text scan, something like this:
fid_format = '%s '; %USE YOUR OWN FORMAT HERE
fid = fopen(filename);
C = textscan(fid,fid_format);
fclose(fid);
Then loop over each row and do a string check and make a new "reduced" text:
string_size = size(C); for iRow = 1:string_size(1) if regexpi(char(C(iRow,1)),'*') %Do nothing else Reduced_Text{iRow,1} = char(C(iRow,1)); end end
5 个评论
huda nawaf
2011-10-11
Kevin
2011-10-11
If you know which rows you want to exclude you can do something like this:
exclude = [1;4;10;12]; %EACH ROW YOU WANT TO EXCLUDE
count = 1;
for iRow = 1:length(text)
exclude_row = 0;
for iExclude = 1:length(exclude)
if exclude(iExclude) == iRow
exclude_row = 1;
end
end
if exclude_row == 0
new_text{count,1} = text(iRow); %REDUCED TEXT
count = count + 1;
end
end
huda nawaf
2011-10-11
huda nawaf
2011-10-11
Kevin
2011-10-11
You should state how you are trying to differentiate the rows so we can help you a bit better up front next time.
If you open your text file with excel (WITH NO TAB DELIMIT) and save it as an excel file with NO delimiting, you can use this code to get it to work:
filename = 'SampleText.xlsx'; %Your excel file with the raw text that is not delimited
[Data Text] = xlsread(filename);
Text_Size = size(Text);
count = 1;
for iRow = 1:Text_Size(1)
tempchar = Text{iRow,1}(1); %Grab first character in cell
tempnum = str2num(tempchar); %Try to convert first character to number
if tempnum >= 0 %If str2num answer is '[]' do nothing and skip
New_Text{count,1} = Text(iRow,1);
count = count + 1;
end
end
bym
2011-10-11
you can try this:
x = textscan(fid,'%f %s %f','delimiter','\t','CommentStyle','*')
3 个评论
huda nawaf
2011-10-12
huda nawaf
2011-10-12
bym
2011-10-12
use isnan() to find nan's. It is customary to 'accept' an answer that solved your question, so others can benefit.
类别
在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息
2011-10-11
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
