Mismatch between file and format character vector but the CSV file contains only numerics?
조회 수: 67 (최근 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!