xlsread and fwrite: remove unwanted single quotes from strings

Question

Shane Ullman 2012-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/35348-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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Richard 2012-4-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/35348-xlsread-and-fwrite-remove-unwanted-single-quotes-from-strings#answer_44304

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.