use comma as decimal seperator

2011 9 27
7 个回答
回答已采纳
更新时间：2023 7 18
54 次查看（30 天）

1 个投票

Hi,
i have a simple question and this is my last try, as i've been searching the web all morning:
Is there a way to use comma as decimal seperator instead of a period/dot in matlab?
Even maybe only in figures/axis format?
Thanks, any help is gratefully appreciated!
ps: i set the reagional settings in Windows/MacOS (using both) to German (--> Comma)

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

 采纳的回答

Jan
Jan 2011-9-27

2 个投票

The answer is easy: no.
Using the comma is a German feature. In the world of scientific computing the dot is always used as decimal separator. Only Excel is affected by this setting, and in consequence importing data from Excel to MATLAB can be substantially irritating.

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Not only German but also a French feature ;)
Jan
Jan 2011-9-27
编辑：Walter Roberson 2019-3-23
@Aurelien: In deed? After a short web research I found out, that my opinion about the freaky Germans is wrong, see http://en.wikipedia.org/wiki/Decimal_mark .
Comma users: Albania, Andorra, Argentina, Armenia, Austria, Azerbaijan, Belarus, Belgium, Bolivia, Bosnia and Herzegovina, Brazil, Bulgaria, Cameroon, Canada (French-speaking), Chile, Colombia, Costa Rica, Croatia (comma used officially, but both forms are in use elsewhere), Cuba, Cyprus, Czech Republic, Denmark, Dominican Republic, Ecuador, Estonia, Faroes, Finland, France, Germany, Greece, Greenland, Honduras, Hungary, Iceland, Indonesia, Italy, Kazakhstan, Latvia, Lebanon, Lithuania, Luxembourg (uses both marks officially), Macau (in Portuguese text), Macedonia, Moldova, Mongolia, Morocco, Netherlands, Norway, Panama, Paraguay, Peru, Poland, Portugal, Romania, Russia, Serbia, Slovakia, Slovenia, South Africa (officially[14]), Spain, Sweden, Tunisia, Turkey, Ukraine, Uruguay, Venezuela, Vietnam.
Jan
Jan 2017-3-22
@Antonio: Of course, "Italy" is contained in the list of countries already.
Enri
Enri 2019-3-22
" importing data from Excel to MATLAB can be substantially irritating."
  1. Amen
  2. Exporting data from Matlab to Excel is irritating as well.
Boris Povazay
Boris Povazay 2023-7-17
Well - the decimal comma is no German feature, but the decimal point is an US-of-American one...
have a look: Wikipedia Decimal_separator
and as we all know the US suffers from its own imperialistic weigth, not being able to accept that the world has moved on - forward towards a metric international system. ;-)
Stephen23
Stephen23 2023-7-18
" importing data from Excel to MATLAB can be substantially irritating... Exporting data from Matlab to Excel is irritating as well."
Out of personal curiousity, would you care to explain specifically why?
Walter Roberson
Walter Roberson 2023-7-18
IMHO, MATLAB could make it easier to control cell format and insertion of macros in .xls* files.
And perhaps even make it easier to cram multiple distinct tables inside the same worksheet, since some people prefer to build spreadsheets more for presentation purposes than for machine processing.
My own work has never needed to insert an excel macro, and has seldom needed to change the format for a column or area. The times I have wanted to change the format for a column, it has (as best I can recall) had to do with wanting to change a time representation format.

请先登录，再进行评论。

更多回答（6 个）

Patrick
Patrick 2011-9-27

0 个投票

Thanks anyway, i fear Jan Simon is right ;-( poor old Europe

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Boris Povazay
Boris Povazay 2023-7-17
Well, the opposite is true ... poor old imperial system and stubborn USA. 🤔

请先登录，再进行评论。

Daniel Gregorius
Daniel Gregorius 2018-5-3
编辑：Daniel Gregorius 2018-5-3

0 个投票

Hey. When dealing with this problem, this is what I came up with. It's an extract of a GUI. People kept entering values with comma (,) instead of a point (.) and then it didn't work so I thought of the following code, that seems to work. I am still not sure if I have thought of everything and this is probably alot more complicated than it should be. Hopefully this still helps. It basically converts input with comma as decimal seperator into a value seperated by decimal point.
x=str2num(get(handles.point,'String'));%get point - everything alright if the delimiter is a .
if size(x,2)>1 %it's not a . but a ,
strx=get(handles.point,'String'); %need to check for sign
splitstrx=strsplit(a1,','); %try to extract length of 2nd string, divide x(2) by 10^strlength
if strx(1)=='-'
x=x(1)-x(2)/10^strlength(splitstrx(1,2)); %it's negative, need to substract 2nd string
else
x=x(1)+x(2)/10^strlength(splitstrx(1,2)); %it's positive
end
end

2 个评论
显示 无 隐藏 无

Stephen23
Stephen23 2019-3-23
x = str2double(strrep(get(handles.point,'String'),',','.'))
Or in a more general case:
x = str2double(strrep(str,',','.'))
This works perfectly fine for me. Short and simple.
Thanks a lot.

请先登录，再进行评论。

Johannes Kalliauer
Johannes Kalliauer 2020-11-30

0 个投票

For Matrixes to CSV I recommend on linux/Mac-machines (On Windows you have to install sed)
writematrix(MyMatrix,filename,'Delimiter',';')
system(['exec sed -i "s/\./,/g" ',filename]);

类别

在 帮助中心 和 File Exchange 中查找有关 Environment and Settings 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by