load a txt file with variable header

5 views (last 30 days)
CSCh
CSCh on 14 Dec 2020
Commented: CSCh on 20 Dec 2020
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 Comments
dpb
dpb on 14 Dec 2020
There's a 'CommentStyle' in textscan or readtable
You might be surprised at how well just using detectImportOptions work, too.
CSCh
CSCh on 15 Dec 2020
Can you please give me an example how to use detectImportOptions for my issue?

Sign in to comment.

Answers (1)

Gouri Desai
Gouri Desai on 16 Dec 2020
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:

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!