How to remove rows with any string from matrix

1 view (last 30 days)
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:
1 0
0 1
0 2
0 3
1 0
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 Comments
Aidan O'Farrell
Aidan O'Farrell on 25 Jun 2014
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!

Sign in to comment.

Accepted Answer

Jos (10584)
Jos (10584) on 25 Jun 2014
Edited: Jos (10584) on 25 Jun 2014
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 Comment
Aidan O'Farrell
Aidan O'Farrell on 25 Jun 2014
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

Sign in to comment.

More Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 25 Jun 2014
Edited: Azzi Abdelmalek on 25 Jun 2014
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))

Categories

Find more on Data Import and Export in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!