how to read csv file containing text and number

328 views (last 30 days)
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.

Answers (1)

Image Analyst
Image Analyst on 13 Mar 2015
Try this:
t = readtable('Fulldata.csv');
  5 Comments
Yu Wang
Yu Wang on 13 Oct 2021
lol struggling so long with importing date from csv. Thanks

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!