MATLAB: Read numbers and characters

charnumbers

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?

Best Answer

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.
Related Question