how can I convert comma with semicolan and then again point with comma for a multiple csv files?

1 次查看（过去 30 天）
Mohammed Cha
Mohammed Cha 2020-12-6
评论： Ameer Hamza 2020-12-6
Hello Matlab Helpers,
I have some csv files (english) which i need to convert in german version. I have not done it before. Can anyone help me please?
What i need to do is
I want to convert first 1. comma with semicolan and then again
2. point with comma for same csv file
and these same ruling for all other csv files and want to save it with csv. format.
My trial but getting error that *Invalid file identifier*:
P = 'C:\Users\Cha\Desktop';%relative/absolute path to the folder where the files are saved';
S = dir(fullfile(P,'*.csv'));
for k = 1:numel(S)
myfilename=sprintf('scope_%d.csv',k);
fidi=fopen(myfilename,'rt')
mydatacoma=textscan(fidi,'%s%s','CollectOutput',1);
fclose(fidi)
mydataadot{k}=strrep(mydatacoma,',',';');
myfinal{k}=strrep(mydataadot{1},'.',',');
end
Thank you very much in advance
Regards,
Cha

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

采纳的回答

Ameer Hamza
Ameer Hamza 2020-12-6
Try this
str = fileread('scope_0.csv');
str = replace(str, {',', '.'}, {';', ','});
f = fopen('outfile.csv', 'wt');
fprintf(f, '%s', str);
fclose(f);
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

产品


版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by