Filter löschen
Filter löschen

Using READTABLE function with 'TreatAsEmpty', Can I index which locations were changed?

2 Ansichten (letzte 30 Tage)
Hello,
I have several excel files, that I am reading into Matlab to reformat and combine. These files are really messy and contain several strings {"NM", "NA", "ICE", & etc} intermixed with numeric values. I know I can remove all of these strings and treat them as empty when I use the readtable function, since I need the numeric value to in fact be numeric values (rather than strings containing numbers). However, I need to denote if that location actually contained one of those strings originally. Is there a way to index these for later combination? OR a better way to do this altogether?
Thanks, Melissa

Antworten (0)

Kategorien

Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by