How to convert a csv file with numbers and text that numbers are separated by commas to a new csv file with dots instead

12 次查看（过去 30 天）

显示更早的评论

Saray 2023-5-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1966254-how-to-convert-a-csv-file-with-numbers-and-text-that-numbers-are-separated-by-commas-to-a-new-csv-fi

评论： Saray 2023-5-18

采纳的回答： Oskar Kilgus

在 MATLAB Online 中打开

hi everyone

I have a csv file that is contaning numbers and text and numbers are seperated by comma. I want to have new csv file that contain same text and numbers but instead of comma, numbers seperated by dot. I used these codes but it gives me error and it says i can't use strrep. Could you please help me with that. Thank you in advance

df2=readtable("export_1_hour_data.csv")
M=df2(1:end,2:3)
D=strrep(M, ',', '.')
writematrix(D,"Temp_Dot_Banana5.csv");

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Oskar Kilgus 2023-5-17

https://exceltable.com/en/formatting/change-comma-to-decimal-point

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

Saray 2023-5-18

Thank you

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by