How to replace a string with another string in a Matlab table
84 views (last 30 days)
Show older comments
Hi,
I have a table that has 'N/A' in some of the column cells. I want to replace 'N/A' by ''. Would anyone tell me how to do that?
Thanks,
Jennifer
0 Comments
Accepted Answer
Walter Roberson
on 28 Aug 2015
Example:
t.Var1(strcmp(t.Var1,'N/A')) = {''};
6 Comments
Stephen23
on 7 Jan 2023
Edited: Stephen23
on 7 Jan 2023
"Please provide some code/hint to remove it"
Rather than removing them, the best approach is to avoid them in the first place (hint: as Walter Roberson already wrote, you can use the READTABLE options, e.g. TreatAsMissing). If you clicked the paperclip button to upload a sample data file then someone could probably help you with that.
Ashishkumar Gupta
on 7 Jan 2023
Thanks @Stephen23, Treatasmissing worked....I did not know the exactword to write in readtable(), that's y could not understand @Walter Roberson.
Now it worked!!
More Answers (1)
Image Analyst
on 27 Aug 2015
Look at the isnan() function and I'm sure you'll find the way.
0 Comments
See Also
Categories
Find more on Logical in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!