I need to convert comma ',' to dot '.'

Hi, I have a set of txt files that contain only a set of numbers that have decimals, but have a comma and not a dot as a separator (for example, there is 1567,987 and not 1567.987). Is there a script that allows you to do this conversion?

I could use matlab's "find & replace" option and import the files later, however, since there are so many files I would like to do something more automated with a script.

[Stephen23]

If your actual goal is to import the data then READTABLE et al will correctly parse files with decimal commas:

https://www.mathworks.com/matlabcentral/answers/822895-how-to-internally-change-decimal-separator-while-importing-data-from-a-csv

Answer 1

[Sulaymon Eshkabilov]

Check out this very sweet answer given by Jan:

https://www.mathworks.com/matlabcentral/answers/51399-replace-comma-by-dot

[Jan]

I can confirm, that this is a good advice. :-)

[Sulaymon Eshkabilov]

Thanks Jan :)

Answer 2

[Star Strider]

One option in detectImportOptions (introduced in R2016b and updated in later releases) in Parameters for Text Files Only allows the definition of:

'ThousandsSeparator' — Characters that indicate the thousands grouping

and:

'DecimalSeparator' — Characters indicating decimal separator

There is no direct URL for these, so click on the second link and scroll down to them.

.