Mismatch between file and format character vector but the CSV file contains only numerics?
17 ビュー (過去 30 日間)
古いコメントを表示
I am receiving this error when trying to read a csv file that appears to contain only numeric values:
Could there be something wrong with the format of the values in the csv file? Each value ends in a newline, except for the last one.
0 件のコメント
採用された回答
per isakson
2019 年 6 月 18 日
編集済み: per isakson
2019 年 6 月 19 日
dlmread() fails to read and convert quoted digits, e.g. "123","456","789". Neither does csvread(). See Comma-separated values. On R2018b
>> dlmread('cssm.txt')
Error using dlmread (line 147)
Mismatch between file and format character vector.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> "123","456","789"\n
>> csvread('cssm.txt')
Error using dlmread (line 147)
Mismatch between file and format character vector.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> "123","456","789"\n
Error in csvread (line 48)
m=dlmread(filename, ',', r, c);
Proposal:
Use the interactive tool Import Data to read the data directly or create a customized function.
1 件のコメント
Walter Roberson
2019 年 6 月 18 日
There is the inherent problem that double-quoted numbers are to be considered character strings in csv files, not numeric.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Import and Analysis についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!