MATLAB Answers

textscan with formatted input data

1 view (last 30 days)
Shawn Grooms
Shawn Grooms on 7 Oct 2019
Edited: per isakson on 10 Oct 2019
I am trying to read an input csv data file with a lot of formatting, example below, and I need to pull it into MATLAB, even if it's in a rough state and needs additional post processing afterwards. The data is separated by commas however each data item is in quotations, and some items are in brackets as well. I've tried a variety of textscan data format options but they don't seem to be working. I have one header row as well, I replaced the header row here with just a generic statement. Any help is appreciated.
***Header Row
"154574","276:13:27:29.905(Bus_Monitor_Card4_core_0)","Type1","1","false","false","false","true","1","true","22","45056","28","276:13:27:29.904576","[64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]","false","31","31","65535","31"
"154808","276:13:27:30.139(Bus_Monitor_Card4_core_0)","Type1","1","false","false","false","false","5","true","22","45056","26","276:13:27:29.940411","[16384, 0, 1, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]","false","31","31","65535","31"
"154808","276:13:27:30.139(Bus_Monitor_Card4_core_0)","Type1","1","false","false","false","false","5","true","22","45056","26","276:13:27:29.990412","[16384, 0, 1, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]","false","31","31","65535","31"
"154808","276:13:27:30.139(Bus_Monitor_Card4_core_0)","Type1","1","false","false","false","false","5","true","22","45056","26","276:13:27:30.040410","[16384, 0, 1, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]","false","31","31","65535","31"
"154808","276:13:27:30.139(Bus_Monitor_Card4_core_0)","Type1","1","false","false","false","false","5","true","22","45056","26","276:13:27:30.090412","[16384, 0, 1, 259, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]","false","31","31","65535","31"
  6 Comments
Stephen Cobeldick
Stephen Cobeldick on 7 Oct 2019
@Shawn Grooms: please use comments for commenting. Answers are for answering the original question.

Sign in to comment.

Answers (1)

Jeremy Hughes
Jeremy Hughes on 7 Oct 2019
This should be able to read this without much issue.
opts = detectImportOptions(filename)
T = readtable(filename,opts)

Tags

Products

Community Treasure Hunt

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

Start Hunting!