HOW TO REMOVE QUOTE MARK ?

3 次查看（过去 30 天）
Amr Hashem
Amr Hashem 2015-9-17
评论： Amr Hashem 2015-9-17
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 个评论
Image Analyst
Image Analyst 2015-9-17
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 个）

Jon
Jon 2015-9-17
What happens if you try
tnum = str2num(cell2mat(t));
  2 个评论
Walter Roberson
Walter Roberson 2015-9-17
str2double() is better than str2num()
Amr Hashem
Amr Hashem 2015-9-17
an error:
Error using ==> cell2mat at 55
Cannot support cell arrays containing cell arrays or
objects.

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2015-9-17
str2double(t)
  1 个评论
Amr Hashem
Amr Hashem 2015-9-17
it converts all cells to NAN
(4259*1 double ) but all are NAN

请先登录，再进行评论。

类别

在 Help Center 和 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