csvread file containing text
28 次查看(过去 30 天)
显示 更早的评论
Hi I have a CSV file as follow (it is only an example, the real file is much bigger)
text1 text2
numb1 numb2 text3 num3 num4 ...
numb5 numb6 text4 num7 num8 ...
. . .
. . .
. . .
the command M2 = csvread('Test.csv',1,3) works well to save the data after the text column.
I would like to save the first two column starting from the second row.
I tried : M = csvread('Test.csv',1,0,[1,0,2,1])
I have an error in reading the data (I assume because of the text in field 3): Trouble reading 'Numeric' field from file (row number 1, field number 3) ==>
Do you any suggestion please ?
Thank you in advance
0 个评论
采纳的回答
Stephen23
2016-4-28
编辑:Stephen23
2016-4-28
The solution is very simple: use textscan instead. textscan works with files containing mixed (numeric and text) data, whereas the functions csvread and dlmread only read numeric data.
When you have this kind of task it is easy to browse the help documentation and find all of the file reading/writing functions listed:
and then you can read their descriptions, and pick the best one for your task.
2 个评论
Walter Roberson
2016-4-28
C = textscan(fileID,'%f%f%*[^\n]');
The %*[^\n] will match everything up to the end of the line, and discard it.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!