Converting raw gas chromatograph data to a matrix

2 次查看（过去 30 天）
Nicholas Frank
Nicholas Frank 2015-5-18
评论： Star Strider 2015-5-19
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!

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2015-5-18
If your version of Excel can read it, then the MATLAB xlsread function should be able to as well.
  7 个评论
显示 5更早的评论

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2015-5-18
fid = fopen('SIGNAL1.CSV');
C = textscan(fid,'"%f,%f"', 'CollectOutput', 1);
fclose(fid);
YourData = C{1};
  1 个评论
Star Strider
Star Strider 2015-5-19
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by