Extract Numbers from a String
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Matthew Brandsema
am 23 Nov. 2014
Bearbeitet: Matthew Brandsema
am 23 Nov. 2014
I have the following string from an excel file.
f 27//1 29//2 5//3 2//4
I want to extract the first number before each // sign. So for example, in this case, I need to extract the numbers 27 29 5 2
I am looking up how to do but but cannot seem to find a straightforward way, would anyone be able to clear things up for me? Thanks!
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 23 Nov. 2014
a='f 27//1 29//2 5//3 2//4'
b=str2double(regexp(a,'\S+(?=//)','match'))
2 Kommentare
Weitere Antworten (1)
the cyclist
am 23 Nov. 2014
Bearbeitet: the cyclist
am 23 Nov. 2014
You want the regexp command. For example,
s = 'f 27//1 29//2 5//3 2//4'
regexp(s,'//')
ans =
5 11 16 21
finds the positions of the //.
You could similarly find the positions of the spaces, and the numbers you want are between them.
You may then need to use str2num (or similar command) to convert the strings to numeric variables.
0 Kommentare
Siehe auch
Kategorien
Mehr zu String Parsing 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!