Cell 'Find And Replace'
No License
cellData=cellNaNReplace (cellData, replaceWith)
Accepts a cell array and a char/integer and replaces all occurrences of NaN in that cell array with the 'replaceWith' value. This is especially useful when using 'readfromexcel' or other excel importers since they sometimes put NaN instead of empty cells.
Example of usage:
a = num2cell([0 1 2 NaN 4]);
b = cellNaNReplace (a,'');
or, if you're dealing with excel spreadsheets, you can use:
Data = readfromexcel(File,'All');
Data = cellNaNReplace (Data,0);
Enjoy.
Cite As
Yoav Mor (2024). Cell 'Find And Replace' (https://www.mathworks.com/matlabcentral/fileexchange/10847-cell-find-and-replace), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Acknowledgements
Inspired by: readfromexcel
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |