Clear Filters
Clear Filters

How to convert cell with numeric and string-nan into TYPE double

2 views (last 30 days)
Dear all, I have a cell with the combination of number and string NaN. May I know how I can convert the content into a double type? The cell is attach together with this thread.
Thanks in advance

Accepted Answer

Matthew
Matthew on 3 Oct 2017
Something like the below works fairly well. Use cellfun to search for numeric values, and save them into the doubles array. Then convert everything else into NaNs (or whatever else you want the NaNs to be).
cr_double = zeros(size(cr_manual))
cr_number = cellfun(@(x) isnumeric(x),cr_manual)
cr_double(cr_number) = [cr_manual{cr_number}]
cr_double(~cr_number) = NaN
  1 Comment
balandong
balandong on 5 Oct 2017
Hi Matthew,
Thanks for the quick reply. Your suggestion work like a charm, really appreciate it.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Type Conversion 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!