convert cell array into double and remove dollar symbol
4 views (last 30 days)
Show older comments
Hi everyone, I was working on an assignment and I got stuck into converting a cell array of the type: a = {'$12,001.87','$0.04','$12,003,887.55','$0.32'}; into numeric values that I can finally sum up. I tried str2double but I have got NaNs probably because of the dollar symbol that I should remove (not sure though). Can someone please help me with this?
0 Comments
Accepted Answer
Jan
on 8 Jul 2017
C = {'$12,001.87','$0.04','$12,003,887.55','$0.32'};
C = strrep(C, '$', '');
C = strrep(C, ',', '');
N = str2double(C)
0 Comments
More Answers (0)
See Also
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!