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

34 visualizaciones (últimos 30 días)
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!

Respuesta aceptada

Stephen23
Stephen23 el 27 de Oct. de 2021
Use READMATRIX and set the Delimiter and DecimalSeparator to values that suit your file.
  5 comentarios
Stephen23
Stephen23 el 28 de Oct. de 2021
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
Paulo Henrique Março el 28 de Oct. de 2021
Hi Stephen
Fantastic!
Now the problem is completely solved.
You saved my week!
Thank you a lot!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Programming en Help Center y File Exchange.

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by