Converting raw gas chromatograph data to a matrix
1 view (last 30 days)
Show older comments
Nicholas Frank
on 18 May 2015
Commented: Star Strider
on 19 May 2015
My gas chromatograph has the ability to output .csv files and I can open them in excel. Excel has the ability to use the text to columns function and remove the comma, allowing the csv data to be separated into two columns. However, I would much rather do this in MATLAB and have everything be automated. But when I try and use the csvread function there is an error because when importing the data from excel to MATLAB, there is now quotation marks surrounding my csv's.
For example, my first value which I need separated is: "0.00333333333333333,869721.594606312"
I know there is a simple solution either using strrep or csvread, but I can't seem to get it right. Any help is appreciated, thank you.
Thanks!
0 Comments
Accepted Answer
Star Strider
on 18 May 2015
If your version of Excel can read it, then the MATLAB xlsread function should be able to as well.
7 Comments
More Answers (1)
Walter Roberson
on 18 May 2015
fid = fopen('SIGNAL1.CSV');
C = textscan(fid,'"%f,%f"', 'CollectOutput', 1);
fclose(fid);
YourData = C{1};
1 Comment
Star Strider
on 19 May 2015
Brilliant!
I wish I’d thought to include the double quotes and the comma in the format descriptor when I experimented with textscan. That eliminates both as problems, with no further data manipulation needed. Something to remember.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!