How to read a csv with 30000 rows of data which are both numbers and texts?

How I can read a csv which contains about 30.000 rows of data that are both text and numbers? I have tried with xlsread and readtable commands but it stores the first 12650 rows.

Answer 1

[Walter Roberson]

You will probably need to use textscan()

Does the file have the same number of fields on each line?

Is it possible that the file changes formats after 12650 lines?

[Kelly Kyriakou]

The file doen't have the same number of fields on each line. There is a pattern in every 1000 rows approximately. When I read with xlsread it stores 12745 rows and when I read with readtable it stores 12637 rows.

[Kelly Kyriakou]

I noticed that if I convert this file to xlsx and try to read in matlab it reads all the rows (30770) using both xlsread command and readtable command.

[Walter Roberson]

Ah. The problem is solved for your purposes then?

[Kelly Kyriakou]

Yes I suppose, but I can't understand the reason...