Changing a string to a number

3 views (last 30 days)
Jason
Jason on 5 Feb 2014
Commented: Azzi Abdelmalek on 6 Feb 2014
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.

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 5 Feb 2014
A={1 2 'N/A';3 'B' 5;'N/A' 0 0} %Example
A(strcmp(A,'N/A'))={0}
  2 Comments
Jason
Jason on 6 Feb 2014
Thanks, this got me part of the way there, but it doesn't work for tables.
Azzi Abdelmalek
Azzi Abdelmalek on 6 Feb 2014
Please post an example

Sign in to comment.

Categories

Find more on Characters and Strings in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!