Changing a string to a number

2014 2 5

1 个回答

2 次查看（30 天）

0 个投票

I have a table that contains both numerical values as well as text. I would like to replace the string 'N/A' to the number 0 in the table.

Thanks for helping out a true beginner.

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

Azzi Abdelmalek 2014-2-5

0 个投票

A={1 2 'N/A';3 'B' 5;'N/A' 0 0}  %Example
A(strcmp(A,'N/A'))={0}

Jason 2014-2-6

Thanks, this got me part of the way there, but it doesn't work for tables.

Azzi Abdelmalek 2014-2-6

Please post an example

在帮助中心和 File Exchange 中查找有关 Characters and Strings 的更多信息

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

Translated by