CSV read
显示 更早的评论
Hi,
I've tried to use the import data function for reading numeric data and text from the same CSV file. Each line of the header (first 10 lines) starts with a semicolon. The numeric data starts in row 11. That is represented in 4 columns. Sometimes there is an error message between the data rows starting with a semicolon. When I use the importdata function the data reading stops at the first error message line, though it is followed by useful data. Can anyone suggest me a way for reading in the whole file and accepting lines starting with semicolons?
THanks!
1 个评论
Fangjun Jiang
2011-9-7
Hard to tell without an example and your expected outcome.
采纳的回答
Walter Roberson
2011-9-7
0 个投票
textscan() with Headerlines set to 10, and with CommentStyle set to ';'
2 个评论
Laszlo Grand
2011-9-7
Walter Roberson
2011-9-8
filename = 'YourInput.csv';
outname = ['NEW_' filename];
infid = fopen(filename, 'rt');
outfid = fopen(outname, 'wt');
for K = 1:10
fwrite(outfid,fgets(infid));
end
while true
thisline = fgets(infid);
if ~ischar(thisline); break; end
if thisline(1) ~= ';'; fwrite(outfid, thisline); end
end
fclose(infid);
fclose(outfid);
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
2011-9-7
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
