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

[Rik]

What have you tried so far yourself? Splitting the char on newlines is the easiest part, but splitting the char to columns should not be too hard either.

[Kartick]

I have tried following things:

str=convertCharsToStrings(cmdout)

t=table(str)

cel=table2cell(t)

array=table2array(t)

st=table2struct(t)

s=reshape(array,[1,15])

but none has helped. Thanks for response

Answer 1

[Stephen23]

cmdout = fileread('cmdout.txt') % fake data

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
     '

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))

tbl = 6×2 table
                            Received       Sent   
                           __________    _________

    Bytes                  4178033452    510183200
    Unicast packets            124836      2463020
    Non-unicast packets         30732        38568
    Discards                        0            0
    Errors                          0            0
    Unknown protocols               0            0

Method two: DOUBLE:

tmp = regexprep(vertcat(tkn{:}),'^\d+$','$&   NaN');
tbl = array2table(str2double(split(tmp(:,2))), 'RowNames',tmp(:,1), 'VariableNames',hdr(2:end-1))

tbl = 6×2 table
                            Received        Sent   
                           __________    __________

    Bytes                   4.178e+09    5.1018e+08
    Unicast packets        1.2484e+05     2.463e+06
    Non-unicast packets         30732         38568
    Discards                        0             0
    Errors                          0             0
    Unknown protocols               0           NaN

[Kartick]

Sir it's working. I would like to thank you for your valuable time and support.

Thanks again for your guidance and mentorship.

Answer 2

[Eric Sofen]

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.

[Jeremy Hughes]

% 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]

sir

writeline function is not recognized by matlab

[Jeremy Hughes]

https://www.mathworks.com/help/matlab/ref/writelines.html

This was introduced in R2022a, so you might be using an earlier version, (or missing the "s" at the end).

Answer 3

[Walter Roberson]

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);

[Kartick]

Sir, The return result is :

topic =

0×1 empty string array

received =

0×1 empty double column vector

sent =

0×1 empty double column vector

T =

0×3 empty table

sir, there is no data.

[Rik]

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]

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]

Thank you very much sir. This is working.

[Rik]

If a solution works, you should mark it as accepted answer.

[Kartick]

Sir actually I have marked a response as accepted which was suggested earlier. This too was also working and I am unable to accept this answer.

[Rik]

No, you flagged a comment. A flag is meant to attract the attention of an admin, not to indicate the solution to a question.

You can indeed not accept a second answer. What you can do is unaccept the previous one, and accept this answer.