load a txt file with variable header

8 次查看（过去 30 天）
CSCh
CSCh 2020-12-14
评论： CSCh 2020-12-20
Hi Everyone,
i want to "load" multiple txt-files but they have variable header. However all files looks like this:
*bla bla
*bla
*bla
....(between 50-50 rows)
then the main part begins, containing tabstop separated, 29 col and variable rows ~200 with my sensor data, however containing also not only numerics also "Nan" too.
I need some help to just start integrating the textfile skipping all rows beginning with "*" . Or better all rows +1 because the first row of my sensor data starts with "nans".
Thanks
Chris
  2 个评论
dpb
dpb 2020-12-14
There's a 'CommentStyle' in textscan or readtable
You might be surprised at how well just using detectImportOptions work, too.
CSCh
CSCh 2020-12-15
Can you please give me an example how to use detectImportOptions for my issue?

请先登录，再进行评论。

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

回答（1 个）

Gouri Desai
Gouri Desai 2020-12-16
I understand that you are trying to read multiple text files with varying headers. Also, you want to read specific rows/columns of data beginning with a ‘*’.
detectImportOptions is a great way to choose the type of data, row and column, or the start and end conditions on data points in a file. Check out the Name, Value pairs in it's documentation page.
You can use it in combination with readtable to obtain a table having the data points satisying the properties set with detectImportOptions.
Do check this resource for more information:
Importing tabular data into a matlab table with customized options

类别

在 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!

Translated by