result in table format or excel format
显示 更早的评论
I am using following code:
command='netstat -e'
[status,cmdout]=system(command)
Result:
cmdout =
'Interface Statistics
Received Sent
Bytes 4178033452 510183200
Unicast packets 124836 2463020
Non-unicast packets 30732 38568
Discards 0 0
Errors 0 0
Unknown protocols 0
'
The cmdout is char file (1x371).
I wish to get this data in table form (row x column) or in excel format or as matrix. Please guide. Thank you in advance
采纳的回答
cmdout = fileread('cmdout.txt') % fake data
hdr = regexp(cmdout,'^\s*(\S+\s\S+)\s+(\S+)\s+(\S+)\s+(.*)','tokens','once');
tkn = regexp(hdr{end},'(\S+(\s\S+)*)\s+(\d+(\s+\d+)*)','tokens');
Method one: UINT64:
tmp = vertcat(tkn{:});
mat = sscanf(sprintf(' %s',tmp{:,2}),'%lu',[2,Inf]).';
tbl = array2table(mat, 'RowNames',tmp(:,1), 'VariableNames',hdr(2:end-1))
Method two: DOUBLE:
tmp = regexprep(vertcat(tkn{:}),'^\d+$','$& NaN');
tbl = array2table(str2double(split(tmp(:,2))), 'RowNames',tmp(:,1), 'VariableNames',hdr(2:end-1))
更多回答（2 个）
Eric Sofen
2022-12-30
移动：Rik
2022-12-30
1 个投票
It's a little circuitous, but you can use writelines to write the char vector to a text file, then use the power of readtable to parse it into a table in MATLAB.
3 个评论
Jeremy Hughes
2022-12-30
编辑：Jeremy Hughes
2022-12-30
% command='netstat -e';
% [status,cmdout]=system(command)
Above doesn't work on Answers, so simulating the output:
cmdout = [
"Interface Statistics";
"";
" Received Sent";
""
"Bytes 4178033452 510183200";
"Unicast packets 124836 2463020";
"Non-unicast packets 30732 38568";
"Discards 0 0";
"Errors 0 0";
"Unknown protocols 0"];
writelines(cmdout,"data.txt");
T = readtable("data.txt","FileType","fixedwidth","NumHeaderLines",2)
Kartick
2022-12-31
Jeremy Hughes
2022-12-31
This was introduced in R2022a, so you might be using an earlier version, (or missing the "s" at the end).
Walter Roberson
2022-12-30
You have fixed-width columns. Use array indexing:
topic = string(cmdout(5:end, 1:22));
received = double(string(cmdout(5:end, 23:35)));
sent = double(string(cmdout(5:end, 36:end)));
T = table(topic, received, sent);
7 个评论
Kartick
2022-12-31
Rik
2022-12-31
This indexing assumes a char array split into multiple lines, so that step should still be implemented. I don't understand why you did not receive an error instead of empty arrays.
Walter Roberson
2023-1-1
cmdout = char(regexp(cmdout, '\r?\n', 'split'));
topic = string(cmdout(5:end, 1:22));
received = double(string(cmdout(5:end, 23:35)));
sent = double(string(cmdout(5:end, 36:end)));
T = table(topic, received, sent);
Kartick
2023-1-8
Rik
2023-1-8
If a solution works, you should mark it as accepted answer.
类别
在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Translated by 
