How to change string to number in excel file?

3 次查看（过去 30 天）
hdr mhr
hdr mhr 2013-2-14
Hi,
I have an excel file that contains string (y and n). I read the file using xlsread. Now I want to replace all the y's with 1 and all the n's with 0. How can I do that?

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

采纳的回答

Jan
Jan 2013-2-14
data = {'y', 'y', 'n', 'y'};
value = nan(size(data));
value(strcmp(data, 'y')) = 1;
value(strcmp(data, 'n')) = 0;

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by