Extract Numbers from a String
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Matthew Brandsema
il 23 Nov 2014
Modificato: Matthew Brandsema
il 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 Commenti
Risposta accettata
Azzi Abdelmalek
il 23 Nov 2014
a='f 27//1 29//2 5//3 2//4'
b=str2double(regexp(a,'\S+(?=//)','match'))
2 Commenti
Più risposte (1)
the cyclist
il 23 Nov 2014
Modificato: the cyclist
il 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 Commenti
Vedere anche
Categorie
Scopri di più su String Parsing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!