ignore some data in file

1 次查看（过去 30 天）
huda nawaf
huda nawaf 2011-10-11
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
Jan 2011-10-11
Please format you text again. Start lines with a space to prevent the automatic joining of lines.
huda nawaf
huda nawaf 2011-10-11
sorry the data is not appeared properly
I will give for each row digit for recognize:
1-1800254325 Othello (1995) 26
2-1800246889 Now and Then (1995) 27
3-1800246848 Persuasion (1995/I) 28
4-Cité des enfants perdus, La (1995) 29
5-1800024450 Shanghai Triad (Yao a yao yao dao waipo qiao) (1995) 30
6-1800242776 Dangerous Minds (1995) 31
7-Twelve Monkeys (1995) 32
8-1800026894 Wings of Courage (1995) 33

请先登录，再进行评论。

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

回答（2 个）

Kevin
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 个评论
显示 3更早的评论
huda nawaf
huda nawaf 2011-10-11
i want ignore each row is not beginning with digits
Kevin
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
bym 2011-10-11
you can try this:
x = textscan(fid,'%f %s %f','delimiter','\t','CommentStyle','*')
  3 个评论
显示 1更早的评论
huda nawaf
huda nawaf 2011-10-12
I try again, I got it
thank you very much.
you solved my problem. really, I'm grateful
bym
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Programming 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by