Convert comma-separated decimal to point-separated decimal

I have a table with 500 rows and 8 columns. The decimal separation is comma (,). However I would like to convert the separation to point(.)

Is it possible to do this without having to loop through the entire table?

Is there any function that permits conversion (something similar to strrep) when working with tables?

[Walter Roberson]

What is the data type of the table at the moment? Is it in a text file of some kind (if so, what?) Is it a cell array of character vectors? Is a MATLAB table() object?

[Darlington Mensah]

It is a MATLAB table object with 8columns. Some columns are text files (usually the first 3 columns, although it is not always this way) and the rest are doubles with comma decimal separation.

[Guillaume]

I was under the impression that matlab always used a dot (point) as a decimal separator for numeric types. Are you sure that "the rest are doubles with comma decimal separation" and not numbers stored as text?

[Darlington Mensah]

Im sorry i was not very clear. Once I import the data (with the readtable function), the decimal comma columns are stored as text. I would like to change convert the comma's to point and then get the element in these columns to be doubles

[Egor Gurov]

Table.VarName = str2double(regexprep(Table.VarName,',','.'));

It works on Matlab 2020b

[Matilda Jacobson]

Thank you Egor, it really helped me and my bachelor project!!

Answer 1

[dpb]

t.Var=str2double(strrep(t.Var,',','.');

for affected each variable 'Var' in table 't'.

Can generalize into loop or use whatever is most convenient addressing depending on structure of the table, just ensure the form used returns the variable content of the column not another table. See the

doc table  % section on addressing for details

Answer 2

[Walter Roberson]

TheTable{:, ColumnNumber} = str2double( regexprep(TheTable{:,ColumnNumber}, ',', '.') );