Convert german numbers from excel to matlab (change comma versus point)

Question

Steffen Thomas 2022-9-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1813595-convert-german-numbers-from-excel-to-matlab-change-comma-versus-point

评论： Steffen Thomas 2022-9-29

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 个评论
显示无隐藏无

Steven Lord 2022-9-28

How are you reading the data into MATLAB, what function or workflow (the Import Data tool in the Toolstrip?) are you using?

Steffen Thomas 2022-9-28

编辑：Steffen Thomas 2022-9-28

在 MATLAB Online 中打开

i have used google to find a solution. Normally it should possible to change such signs in strings. But i have a problem to read in this german numbers as strings.

This is my code:

experi=[
    28,97
    54,76
    65,01
    80,56
    52,90
    ];
lauf=length(experi);
exper=zeros(lauf,1);
exper_orig=exper;
for i=1:lauf
    c1s=string(experi(i,1))+"."+string(experi(i,2)); %here i will build the number but in the case of 65,01 the resulting number is 65.1
    c1=double(c1s);
    exper(i)=c1*10^atype(i);
end

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Fabio Freschi 2022-9-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1813595-convert-german-numbers-from-excel-to-matlab-change-comma-versus-point#answer_1062495

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 个评论
显示 2更早的评论隐藏 2更早的评论

Steffen Thomas 2022-9-28

Many thanks,

i will check this. Now its look good. With declering the range it can be useful for me.

Steffen Thomas 2022-9-29

Hello,

surprisingly readtable read numbers in a correct matter without declaring 'DecimalSeparator' (this gives an error). And using excel online one onedrive i can work with the matlab script and excel at the same time on the same document.

Many thanks

请先登录，再进行评论。