# How to ignore letters in a numeric cell?

11 Ansichten (letzte 30 Tage)
Daniel Tanner am 28 Jan. 2020
Kommentiert: Daniel Tanner am 29 Jan. 2020
I have imported a vector into MatLab from excel which was originally imported from ANSYS. I would like to plot this vector against another one, however each entry has a 'mm' after it, like so:
Is there a way in MatLab to ignore the letters and just read the numbers so I can produce a plot? I know I could manually do this but I have over 200+ entries.
Any help is greatly appreciated, thanks!
##### 2 KommentareKeine anzeigenKeine ausblenden
Are they in cell arrays or a char array (implying that every one is the same length and never more nor fewer digits)?
The example format you have given is not valid as it is a numeric array with characters in it too.
Daniel Tanner am 28 Jan. 2020
It is in a cell array. They go from 0.01mm to 2.9mm.

Melden Sie sich an, um zu kommentieren.

### Akzeptierte Antwort

Bearbeitet: Adam am 28 Jan. 2020
cellfun( @(x) str2double( erase( x, 'mm' ) ), pin_radius )
should convert them to an array of doubles.
If you are using pre R2016b you would have to use something like this instead:
cellfun( @(x) str2double( strrep( x, 'mm', '' ) ), pin_radius )
(Note in that version the 3rd argument to strrep is two consecutive single quotes, not a double quote)
##### 1 Kommentar-1 ältere Kommentare anzeigen-1 ältere Kommentare ausblenden
Daniel Tanner am 28 Jan. 2020
Perfect, thank you!

Melden Sie sich an, um zu kommentieren.

### Weitere Antworten (1)

Stephen23 am 28 Jan. 2020
Simpler and much more efficient with sscanf:
>> C = {'0.01mm';'0.02mm';'0.03mm';'0.04mm'};
>> V = sscanf([C{:}],'%fmm')
V =
0.010000
0.020000
0.030000
0.040000
##### 1 Kommentar-1 ältere Kommentare anzeigen-1 ältere Kommentare ausblenden
Daniel Tanner am 29 Jan. 2020
Thank you!

Melden Sie sich an, um zu kommentieren.

### Kategorien

Mehr zu Cell Arrays 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