convert cell array into double and remove dollar symbol

4 Ansichten (letzte 30 Tage)
Salvatore Lacava
Salvatore Lacava am 8 Jul. 2017
Beantwortet: Jan am 8 Jul. 2017
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?

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Jan
Jan am 8 Jul. 2017
C = {'$12,001.87','$0.04','$12,003,887.55','$0.32'};
C = strrep(C, '$', '');
C = strrep(C, ',', '');
N = str2double(C)

Weitere Antworten (0)

Kategorien

Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by