MATLAB Answers

Change text to numbers in a cell

60 views (last 30 days)
Hi all,
Lets say I have 4 x 2 cell matrix A:
1 'text one' 'text two'
2 '5' 'text two'
3 'text one' 'text two'
4 '10' 'text two'
I want the result of a 4 x 2 cell matrix A of all doubles, exept for the last column. The 'text one' has to be replaced by 1 (double):
1 1 'text two'
2 5 'text two'
3 1 'text two'
4 10 'text two'
When I use a for-loop and if-statement I get the error that matrix dimensions must agree. Below is my faulty code:
for i = 1:size(A,1)
if A{i,2} == 'text one'
A{i,2} == 1
A{i,2} == str2double(A{i,2})

Accepted Answer

Akira Agata
Akira Agata on 8 May 2020
How about the following?
B = replace(A,'text one','1');
B = cellfun(@str2double,B(:,1:end-1),'UniformOutput',false);
A = [B,A(:,end)];
Mike Mierlo van
Mike Mierlo van on 8 May 2020
Now it works. Because I tried some things, my A(:,2) was converted to doubles with NaN's instead of text. Resetting A to the original cell was the solution. thank you!

Sign in to comment.

More Answers (1)

madhan ravi
madhan ravi on 7 May 2020
Edited: madhan ravi on 7 May 2020
V = str2double(string(A)); % <2016a
V(isnan(V)) = 1
Mike Mierlo van
Mike Mierlo van on 11 May 2020
Madhan Ravi. Yes, I editted it after your answer. Your answer worked perfectly on my simplified problem, but I simplified it so far that your solution did not work on my actual table, that consisted of more text columns too.
Walter Roberson. Yes A has more numeric values too. I solved it by converting them to strings for the needed operation.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!