how to read csv file containing text and number

Hi,

I have CSV files containing mixed data(text & number).

[num_data text_data] = xlsread('filename.csv');

but I am getting the same as it is there in the file. I want to read as such every text & number as it is. Please help me how can simply read as it is.

I have attached the files here.

Fulldetails.csv:

RNO                 21234                          21235
Stage Name         AMC.VB10E6T4R30                  AMC.VB10E6T4R31
Day/Start         2014/4/23 02:32                  2014/6/23 22:45
Day/End         2014/4/24 02:56                  2014/6/24 22:55
INT Name         CO_Prt_13+_1230eV_dd_23000V  CO_Prt_13+_1230eV_IRK

Fulldata.csv:

VSt_No    0      0.02
House_No    3.77      4.66
Ext_I            34.87      45.44
A1            5         4.66
A2            0         0.01
A3            45.98      41.9
VVM            43.33      32

Please help, how to do this.

Answer 1

[Image Analyst]

Try this:

t = readtable('Fulldata.csv');

[Mekala balaji]

It gives the following error: ??? Undefined function or method 'readtable' for input arguments of type 'char'.

Error in ==> CSVread at 4 t = readtable('Fulldata.csv');

[Image Analyst]

readtable() came with R2013b. You must have an older version, right? You will have to use textscan() instead.

[Alexander Billington]

Bump. Thank you for answer.. took 3 pages of google to find this

[Yu Wang]

lol struggling so long with importing date from csv. Thanks

[Arun Kumar Kantheti]

Thanks for this answer.