MATLAB Answers

0

HOW TO REMOVE QUOTE MARK ?

Asked by Amr Hashem on 17 Sep 2015
Latest activity Commented on by Amr Hashem on 17 Sep 2015
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 Comment

Image Analyst
on 17 Sep 2015
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?

Sign in to comment.

3 Answers

Answer by Kirby Fears on 17 Sep 2015
Edited by Kirby Fears on 17 Sep 2015
 Accepted Answer

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.

  1 Comment

Amr Hashem on 17 Sep 2015
thanks kirby ... it works

Sign in to comment.


Jon
Answer by Jon
on 17 Sep 2015

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

  2 Comments

Walter Roberson
on 17 Sep 2015
str2double() is better than str2num()
Amr Hashem on 17 Sep 2015
an error:
Error using ==> cell2mat at 55
Cannot support cell arrays containing cell arrays or
objects.

Sign in to comment.


Answer by Walter Roberson
on 17 Sep 2015

str2double(t)

  1 Comment

Amr Hashem on 17 Sep 2015
it converts all cells to NAN
(4259*1 double ) but all are NAN

Sign in to comment.