Load CSV file to matlab and avoiding word written in csv file for data analysis

I have a .csv file which has some words and data in it. If I load the file with words, it does not work. i want to know how to avoid the rows of words in the file when i am loading it.

Thanks

Answer 1

[Laura Proctor]

You can load it using the textscan function. The link will explain more about this function.

If you tell me about the format of the CSV file (i.e. how many headerlines that you want to avoid, and then a sample row of data), I can tell you more about how to use the function.

[Sinhara]

I want to avoid rows 1-9 and 209- up. and some rows in between also

Thank you

[Sinhara]

I have about 20 .csv files which i have to use. can you tell me a method to use those files with textscan function

[Khan]

"x = csvread('File Name',9,0,[9,0, 209,0]);" you can try this command it will load your data from row 9 till to 209 row of only first column ..

Answer 2

[Kevin Claytor]

importdata does a pretty good job of separating header from file information, have you tried that?

[Sinhara]

I'll try that too. thank you

Answer 3

[Reks]

Utilize next solution repair rtf document

This item http://www.rtfrepair.wordrepairtoolbox.com will help you