How to write 2x1 string to csv?

Question

Louise Wilson 2019-9-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478784-how-to-write-2x1-string-to-csv

评论： Walter Roberson 2019-9-6

I have created a 2x1 string array which contains filenames in the first column, and a 'yes' or 'no' in the second column.

I'd like to write this information to an output format, preferrable .csv, how could I do this? Should I be converting from string to another format first?

Thanks!! My work so far:

%Create output array, table with two columns
            sz1=files; %number of rows=number files in folder
            szN=2;     %number of columns=2
            results=strings(sz1,szN);
        
            d(i).name=convertCharsToStrings(d(i).name); %convert filename to suitable format
        
            %Does it look like there is boat noise in the plot?
            answer=input('Can you see boat noise? y/n: \n', 's')
        
        
            if strcmp(answer,'y');
                %store filename in output with 'boat' in second column
                    results(row,1) = d(i).name;
                    results(row,2) = 'yesboat';
            
            elseif strcmp(answer,'n');
                %store filename in output with 'no boat' in second column
                    results(row,1) = d(i).name;
                    results(row,2) = 'noboat';
                
            else
                disp('Input must be Y or N!');
            
            end

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-9-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478784-how-to-write-2x1-string-to-csv#answer_390297

编辑：Walter Roberson 2019-9-4

在 MATLAB Online 中打开

You can convert to a table() object and writetable() with WriteVariableNames set to false.

Or you can do it "manually", by using fopen(), fprintf(), fclose()

Or you can

char(results(:,1) + ',' + results(:,2))

and dlmwrite() that to a .csv file, making sure you use 'delimiter', '' (that is the empty character vector)

If you were using R2019a or later (and thank you for filling in your release!), then you could use writematrix()

2 个评论
显示无隐藏无

Louise Wilson 2019-9-6

Thanks Walter. I had been wanting to use writematrix as I see dlmwrite is no longer recommended nor is writetable. I downloaded a function instead called cell2csv, I think it was called... that someone wrote to do this. It worked perfectly. I don't really understand the steps you said but maybe I will in the future, I'll refer back. Thanks!

Walter Roberson 2019-9-6

writematrix() needs the release after you have.

writetable() is fine for tables of data that is not all the same datatype.

请先登录，再进行评论。

How to write 2x1 string to csv?

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

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to write 2x1 string to csv?

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

采纳的回答

2 个评论 显示 无隐藏 无

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

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

2 个评论
显示无隐藏无