xlsread and fwrite: remove unwanted single quotes from strings

I have written a code to help me write large amounts of code in Java format. My problem is that the strings I am importing from an excel file have single quotes around them, which I don't want. How can I remove them? Or can I make the file without the single quotes in the first place?
Here is my code:
[numData, textData] = xlsread('CSATData.xlsx','Countries');
ncountries = 5;
fid = fopen('datafile.csv', 'w');
for n = 2:1:ncountries+1
matcode = cell2mat(textData(n,1));
matcountry = cell2mat(textData(n,2));
stringcode = mat2str(matcode);
stringcountry = mat2str(matcountry);
fwrite(fid, '<option value="','char');
fwrite(fid, stringcode);
fwrite(fid, '">','char');
fwrite(fid, stringcountry);
fwrite(fid, '</option>', 'char');
fprintf(fid, ',\r\n');
end
fclose('all');
I'm sure there are other things that need cleaning up, but all I want to know is how to remove the single quotes from the output. ie, stringcountry gives me 'United Arab Emirates', but I just want United Arab Emirates. No quotes. Please help.

 Réponse acceptée

Richard
Richard le 13 Avr 2012
The quotes just mean that it is a string. If you type something like stringcountry{1} it should provide the name of the country without the quotations.

1 commentaire

That's great, just needed to do textData{n,1}, no need to convert to string. Thanks for your help.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Environment and Settings dans Centre d'aide et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by