I need to write a code to import multiple csv files, changing delimiter and decimal standard...

Hi guys,

I need to import multiple .csv files. Nonetheless, all my tries are going wrong: the file delimiter (even though it is .CSV, the delimiter is the semicolon (;), and the decimal is the comma (,). Please, I need help. I was doing:

P = 'fullpath';

S = dir(fullfile(P,'*.csv'));

for k = 1:numel(S)

F = fullfile(P,S(k).name);

S(k).data = csvread(F);

end

But I have the message:

Error using dlmread (line 147)

Mismatch between file and format character vector.

Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> (creator description)

Error in csvread (line 48)

m=dlmread(filename, ',', r, c);

Can someone help me, please? Many thanks in advance!

Answer 1

[Stephen23]

Use READMATRIX and set the Delimiter and DecimalSeparator to values that suit your file.

[Paulo Henrique Março]

Hi Stephen,

Thanks for answring it. Please, could you be more specific? I mean, the suggestion is to replace a command or add another one?

[Stephen23]

Replace CSVREAD with READMATRIX, specifying the delimiter and decimal separator to suit your file.

[Paulo Henrique Março]

Stephen,

Thank you!

Please, about the delimiter and decimal separator, I am being unsuccessful. This code is working well, but the file is still wrongly imported:

P = 'path';

S = dir(fullfile(P,'*.csv'));

for k = 1:numel(S)

F = fullfile(P,S(k).name);

S(k).data = readmatrix(F);

end

It is giving-me data separated in 3 columns due the CSV structure, in which the columns are separated by semicolon and decimal by comma. Can you help me with this specification?

Again, thank you!

[Stephen23]

Replace

readmatrix(F)

with

readmatrix(F, 'Delimiter',';', 'DecimalSeparator',',')

If you have any more difficulties, please upload your CSV file by clicking on the paperclip button.

[Paulo Henrique Março]

Hi Stephen

Fantastic!

Now the problem is completely solved.

You saved my week!

Thank you a lot!