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

8 次查看（过去 30 天）

显示更早的评论

Mohammed Cha 2020-12-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/682473-how-can-i-convert-comma-with-semicolan-and-then-again-point-with-comma-for-a-multiple-csv-files

评论： Ameer Hamza 2020-12-6

采纳的回答： Ameer Hamza

在 MATLAB Online 中打开

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

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

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza 2020-12-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/682473-how-can-i-convert-comma-with-semicolan-and-then-again-point-with-comma-for-a-multiple-csv-files#answer_566763

在 MATLAB Online 中打开

Try this

str = fileread('scope_0.csv');
str = replace(str, {',', '.'}, {';', ','});
f = fopen('outfile.csv', 'wt');
fprintf(f, '%s', str);
fclose(f);

5 个评论
显示 3更早的评论隐藏 3更早的评论

Mohammed Cha 2020-12-6

Thank you It works. I found the file also.

Is it possible to make it for multiple files in loop?

Ameer Hamza 2020-12-6

You can process a sequence of file in MATLAB like this: https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

请先登录，再进行评论。

类别

Signal Processing Signal Processing Toolbox Digital and Analog Filters Multirate Signal Processing

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

产品

MATLAB

版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by