read csv file with headers with readtable and get the header
显示 更早的评论
I have a data csv file which include an header with several lines. Each header line starts with the sign %
I have no problem to read the file with readtable and to get the data.
But I would like to get also the header lines which describe my data.
Any suggestion ?
采纳的回答
Walter Roberson
2023-3-15
0 个投票
You will not be able to do this with a single call to readtable() .
Either process the lines separately or else use readcell(). Though with readcell() it is possible you would need to piece lines back together if there just happened to be commas in the lines.
If the files are not huge, sometimes it can be very effective to use fileread() to read the line as a character vector, then use regexp() to pull out the headers, then textscan() the remaining lines -- provided you know their format ahead of time. Though to be honest if you have date/time fields it can be a nuisance to get the %D %T formats right.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
