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

8 ビュー (過去 30 日間)
Paulo Março
Paulo Março 2021 年 10 月 27 日
コメント済み: Paulo Março 2021 年 10 月 28 日
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!

採用された回答

Stephen
Stephen 2021 年 10 月 27 日
Use READMATRIX and set the Delimiter and DecimalSeparator to values that suit your file.
  5 件のコメント
Paulo Março
Paulo Março 2021 年 10 月 28 日
Hi Stephen
Fantastic!
Now the problem is completely solved.
You saved my week!
Thank you a lot!

サインインしてコメントする。

その他の回答 (0 件)

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by