Matlab function to read data files having .Cmn extension

2020 9 23
2 个回答
回答已采纳
更新时间：2020 9 25
4 次查看（30 天）

0 个投票

I want to open and read data files in Matlab having extension '.Cmn'. Please inform me weather there is any Matlab function to open and read this type of data files. I could not attach a sample data file here as the file format is not supported.
I don't know much about CMN files. Some information is provided in the website 'FilExt' as "the CMN file type is primarily associated with Systems Management Server (SMS) by Microsoft Corporation.You need a suitable software like Systems Management Server (SMS) from Microsoft Corporation to open a CMN file."
The website recognizes the file as a 'text file' but I couldnot read the file in Matlab using the 'textscan' function. Also the 'online viewer' in the website reads the data file as:
chum, Kazakhstan
42.99850 74.75110 716.33210
MJdatet Time PRN Az Ele Lat Lon Stec Vtec S4
57372.372569 8.941667 1 319.78 11.39 50.417 64.330 37.91 12.65 -99.000
57372.372917 8.950000 1 319.74 11.58 50.350 64.431 37.85 12.68 -99.000
57372.373264 8.958333 1 319.70 11.77 50.284 64.529 37.69 12.68 -99.000
57372.373611 8.966667 1 319.66 11.96 50.218 64.626 37.53 12.68 -99.000
57372.373958 8.975000 1 319.62 12.15 50.153 64.722 37.42 12.70 -99.000
57372.374306 8.983333 1 319.58 12.34 50.088 64.816 37.20 12.68 -99.000
57372.374653 8.991667 1 319.54 12.52 50.025 64.908 37.00 12.67 -99.000
57372.375000 9.000000 1 319.50 12.71 49.961 64.999 36.84 12.67 -99.000
57372.375347 9.008333 1 319.45 12.90 49.899 65.088 36.57 12.63 -99.000

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2020-9-23
I do not think that content has anything to do with Microsoft Systems Management Server.
Can you attach a sample file?
Dr. Bapan Paul
Dr. Bapan Paul 2020-9-23
Thnak you very much for the prompt response.
As I mentioned earlier, I could not attach a sample data file here as the CMN file format is not supported for attachment. So I manually opened and saved a CMN file in excle format. Please find the file attached.
Walter Roberson
Walter Roberson 2020-9-23
You can attach any file (that is not to big) by zip'ing it and attaching the .zip
Walter Roberson
Walter Roberson 2020-9-23
readtable() has no problem reading the xlsx file, automatically skipping the first two lines.
Do you need the first two lines?
Dr. Bapan Paul
Dr. Bapan Paul 2020-9-24
Thanks for the suggestion. I have now attached a zipped sample CMN data file.
I wish to read directly the CMN data file. And I don't need the first two lines.

请先登录，再进行评论。

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

 采纳的回答

Ameer Hamza
Ameer Hamza 2020-9-23
编辑：Ameer Hamza 2020-9-23

1 个投票

Try the following code. It ignores the first two lines of the file and starts from the line
MJdatet ...
The first row is used as column names for the table, and the rest is used as numeric data.
f = fopen('data.txt');
data = textscan(f, '%s%s%s%s%s%s%s%s%s%s', 'HeaderLines', 2);
data = [data{:}];
fclose(f);
column_names = data(1, :);
numeric_data = data(2:end,:);
numeric_data = cellfun(@(x) str2double(x), numeric_data);
T = array2table(numeric_data, 'VariableNames', column_names);

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Stephen23
Stephen23 2020-9-24
编辑：Stephen23 2020-9-24
Why not just import as numeric?
Importing as character and then converting to numeric does not seem to add any benefit.
Dr. Bapan Paul
Dr. Bapan Paul 2020-9-24
编辑：Dr. Bapan Paul 2020-9-24
Good suggestion. Thanks.
Initially I was searching for a specific matlab function which can read CMN data files. But after this discussion, the problem is solved. CMN files can be read using the textscan function.
Thank you all.
Ameer Hamza
Ameer Hamza 2020-9-24
Yes, that would heve been a better solution.
Following will also work
readmatrix('data.txt', 'NumHeaderLines', 3)

请先登录，再进行评论。

更多回答（1 个）

Dr. Bapan Paul
Dr. Bapan Paul 2020-9-24
编辑：Dr. Bapan Paul 2020-9-25

0 个投票

I can now directly read CMN data files using the below code:
% Read CMN data files
f = fopen('chum350-2015-12-16.Cmn');
file_data=textscan(f, '%f %f %f %f %f %f %f %f %f %f','headerlines',3,'delimiter',' '); % reading the text file and extracting the data in a cell
Raw_data=cell2mat(file_data); % converting cell data into a mat file

类别

在 帮助中心 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by