HOW TO REMOVE QUOTE MARK ?

3 views (last 30 days)
Amr Hashem
Amr Hashem on 17 Sep 2015
Commented: 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
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.

Accepted Answer

Kirby Fears
Kirby Fears on 17 Sep 2015
Edited: Kirby Fears on 17 Sep 2015
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.

More Answers (2)

Jon
Jon on 17 Sep 2015
What happens if you try
tnum = str2num(cell2mat(t));
  2 Comments
Walter Roberson
Walter Roberson on 17 Sep 2015
str2double() is better than str2num()
Amr Hashem
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.


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

Sign in to comment.

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!