load a txt file with variable header

Question

CSCh 2020-12-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/693825-load-a-txt-file-with-variable-header

评论： 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

....(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 2020-12-14

There's a 'CommentStyle' in textscan or readtable

You might be surprised at how well just using detectImportOptions work, too.

CSCh 2020-12-15

Can you please give me an example how to use detectImportOptions for my issue?

请先登录，再进行评论。

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

Answer 1

Gouri Desai 2020-12-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/693825-load-a-txt-file-with-variable-header#answer_576840

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