CSVread does not read file with offset

2020 7 13
1 个回答
回答已采纳
更新时间：2020 7 13
5 次查看（30 天）

0 个投票

I'm attempting to read a csv file with offset but for some reason I get the following error:
Error using dlmread (line 147)
Mismatch between file and format character vector.
Trouble reading 'Numeric' field from file (row number 1, field number 7) ==> Y\n
My file looks like the following:
I'm attempting to use
M = csvread('filename.csv',1,2,[1,5,5,4])
If you can point out where I'm going wrong (and why the error points to Y\n) please let me know. Thanks.

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2020-7-13

1 个投票

csvread() can only skip complete leading text lines, and leading text columns. It is not able to skip trailing text columns even if you give a range parameter.
You should switch to readtable()

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

rough93
rough93 2020-7-13
Thanks Walter, right as usual.
For future reference for other users, you can use the following code with readtable to cut out just the values you want from an alphanumeric table:
T = readtable('filename.csv');
T = T(1:25,3:6); % row boundary, column boundary
A = T{:,:}; % converts selection to matrix (numerical)
Of course, that code came from Walter in another answer...

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2018b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by