Convert german numbers from excel to matlab (change comma versus point)
7 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Steffen Thomas
il 28 Set 2022
Commentato: Steffen Thomas
il 29 Set 2022
I have copied a series of numbers from a German Excel. The comma is there as a decimal point. Now I want to read the numbers into Mathlab and I have also made a way. Unfortunately, it doesn't work with numbers of type xx,0x because I go over a two-column matrix and the leading zero in the second column disappears.
Is there a way to implement the following input in such a way that numbers are read in immediately?
Example:
experi=[
28,97
54,76
65,01
80,56
52,90
];
As result experi (or a converted array) should be real, like:
exper=[
28.97
54.76
65.01
80.56
52.90
];
Can anybody help me please?
2 Commenti
Steven Lord
il 28 Set 2022
How are you reading the data into MATLAB, what function or workflow (the Import Data tool in the Toolstrip?) are you using?
Risposta accettata
Fabio Freschi
il 28 Set 2022
You may try to use readtable to import your data. It reads excel files and has the option 'DecimalSeparator' that can be set to ','
4 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!