Change text to numbers in a cell

7 次查看（过去 30 天）
Mike Mierlo van
Mike Mierlo van 2020-5-7
评论： Mike Mierlo van 2020-5-11
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
else
A{i,2} == str2double(A{i,2})
end
end

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

采纳的回答

Akira Agata
Akira Agata 2020-5-8
How about the following?
B = replace(A,'text one','1');
B = cellfun(@str2double,B(:,1:end-1),'UniformOutput',false);
A = [B,A(:,end)];
  3 个评论
显示 1更早的评论
Akira Agata
Akira Agata 2020-5-8
Could you upload your original cell arrya A?
I have assumed as follows and my code works agains it.
A = {...
'text one', 'text two';
'5', 'text two';
'text one', 'text two';
'10', 'text two'};
Mike Mierlo van
Mike Mierlo van 2020-5-8
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!

请先登录，再进行评论。

更多回答（1 个）

madhan ravi
madhan ravi 2020-5-7
编辑：madhan ravi 2020-5-7
V = str2double(string(A)); % <2016a
V(isnan(V)) = 1
  4 个评论
显示 2更早的评论
madhan ravi
madhan ravi 2020-5-8
Dude when did you edit your question? For sure you edited it after I answered!
Mike Mierlo van
Mike Mierlo van 2020-5-11
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.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by