How to remove rows with any string from matrix

Question

Aidan O'Farrell 2014-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137574-how-to-remove-rows-with-any-string-from-matrix

评论： Aidan O'Farrell 2014-6-25

采纳的回答： Jos (10584)

在 MATLAB Online 中打开

Hello,

I'm trying to remove any rows that have any strings in them in my matric, for example:

name and other jibberish
1 0
0 1
0 2
another name and other words
0 3
1 0
other tosh

and change this to just:

so you can see, it doesn't matter what the string is, its not specific to what the letters in the string are, I just want it removed. Is there an easy way of doing this?

Thanks

3 个评论
显示 1更早的评论隐藏 1更早的评论

Aidan O'Farrell 2014-6-25

I'm trying to import a text file, which in itself is causing me a problem as the rows with strings have different column lengths than the rows with values which have the same column lengths!

Jos (10584) 2014-6-25

For this, my solution should work.

请先登录，再进行评论。

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

Answer 1

Jos (10584) 2014-6-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137574-how-to-remove-rows-with-any-string-from-matrix#answer_142444

编辑：Jos (10584) 2014-6-25

在 MATLAB Online 中打开

Assuming that the rows are lines of a text file:

T = textread('data.txt','%s','delimiter','\n')
T2 = T(~cellfun(@(x) any(isletter(x)),T)) % still strings
VAL = str2num(char(T2)) % numbers

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Aidan O'Farrell 2014-6-25

This works well. But a note to anyone who wants to use this.. makes sure your value do not contain E (obviously) in replacement of decimal places.

Thank you

请先登录，再进行评论。

Answer 2

Azzi Abdelmalek 2014-6-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137574-how-to-remove-rows-with-any-string-from-matrix#answer_142443

编辑：Azzi Abdelmalek 2014-6-25

在 MATLAB Online 中打开

fid = fopen('file.txt');
res={};
while ~feof(fid)
res{end+1,1} =fgetl(fid);
end
fclose(fid);
res(cellfun(@(x) any(isletter(x)),res))=[]
out=cell2mat(cellfun(@str2num,res,'un',0))