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

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

Answer 1

[Ameer Hamza]

Try this

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

[Mohammed Cha]

Dear Ameer Hamza,

Thank you for your response. I am getting error with

undefined function 'replace' for input arguments of type 'cell'

[Ameer Hamza]

I didn't notice that you are using R2015a. Try this code

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

[Mohammed Cha]

Thank you SIr,

The code is working. But i can not see where the file is saving. Could you help me?

Thank you in advance

[Mohammed Cha]

Thank you It works. I found the file also.

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

[Ameer Hamza]

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