Read numbers and characters
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Patrícia Falcão
il 9 Ago 2018
Commentato: Stephen23
il 13 Ago 2018
Hi!
I am trying to read an output from a software that gives me numbers and semicolons, commas, minus and points. The output can be either an excel file ou txt file. If I choose the excel file and open it in matlab, the output is like this:
1
9
.
3
1
2
5
COMMA
2
5
.
1
2
5
0
COMMA
-
1
3
.
7
But I want to matlab recognize if it is a number or a character. In reality, what I want to do is to have "19.3125, 25.1250, -13.7,..." and for that I need matlab to recognize what is a number and not. Can you help me?
5 Commenti
Risposta accettata
Stephen23
il 9 Ago 2018
Modificato: Stephen23
il 9 Ago 2018
Using a simple text file (this will be much easier than processing an Excel file):
>> str = fileread('temp0.txt');
>> str = regexprep(str,'\s+','');
>> vec = sscanf(str,'%fCOMMA',[1,Inf])
vec =
19.312 25.125 -13.700
The test file is attached. If you had actually uploaded your file then I could have tested my code on that: no sample data means I have to invent my own data, which may or may not be the same as what you have.
4 Commenti
Stephen23
il 13 Ago 2018
@Patrícia Falcão: I hope that it helps! Remember to accept the answer that helped you most: this give reputation points to the volunteers who help you on this forum.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Characters and Strings 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!