load a txt file with variable header

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

[dpb]

There's a 'CommentStyle' in textscan or readtable

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

[CSCh]

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

Answer 1

[Gouri Desai]

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

[CSCh]

Thank you Sir, got it!