HOW TO REMOVE QUOTE MARK ?

I have a data (4259*1 cell ) ex: '9'
I want to remove the quotes mark
i try :
j=1;
for i=1:R
D(j)=t{i};
j=j+1;
end
w=D';
but its fake remove them as when i try to use the numbers or copy to excel the quotes appear again
how to remove the quotes or convert them to (4259*1 double)?

1 个评论

Show your code. It looks like you're trying to do something with xlswrite('vital signs.xlsx'.....) but we can't see it. What do you want? Do you want to write t, D, or w to a workbook file? And you want the workbook file to be numbers, not strings with quotes in front of them?

请先登录,再进行评论。

 采纳的回答

Kirby Fears
Kirby Fears 2015-9-17
编辑:Kirby Fears 2015-9-17
Hi amr,
You shouldn't be copying the values out of the variable editor like that.
Try using
xlswrite('output.xlsx',t);
This will directly write the values to excel for you without parentheses.
Hope this helps.

更多回答(2 个)

What happens if you try
tnum = str2num(cell2mat(t));

2 个评论

str2double() is better than str2num()
an error:
Error using ==> cell2mat at 55
Cannot support cell arrays containing cell arrays or
objects.

请先登录,再进行评论。

Walter Roberson
Walter Roberson 2015-9-17

0 个投票

str2double(t)

1 个评论

it converts all cells to NAN
(4259*1 double ) but all are NAN

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Data Type Conversion 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by