MATLAB Answers

Mismatch between file and format character vector but the CSV file contains only numerics?

280 views (last 30 days)
nb4532
nb4532 on 18 Jun 2019
Edited: per isakson on 19 Jun 2019
I am receiving this error when trying to read a csv file that appears to contain only numeric values:
error.PNG
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 Comments

Sign in to comment.

Accepted Answer

per isakson
per isakson on 18 Jun 2019
Edited: per isakson on 19 Jun 2019
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 Comment

Walter Roberson
Walter Roberson on 18 Jun 2019
There is the inherent problem that double-quoted numbers are to be considered character strings in csv files, not numeric.

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Tags

Products


Release

R2018b