Reading ping output using readtable

Question

dormant 2024-2-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2079986-reading-ping-output-using-readtable

评论： Walter Roberson 2024-2-29

I'm creating a text file with ping results (on Linux) that looks like this (timestamp at start).

PING 172.17.102.60 (172.17.102.60) 56(84) bytes of data.
[1707403470.450935] 64 bytes from 172.17.102.60: icmp_seq=1 ttl=64 time=0.378 ms
[1707403471.452695] 64 bytes from 172.17.102.60: icmp_seq=2 ttl=64 time=0.248 ms
[1707403472.482987] 64 bytes from 172.17.102.60: icmp_seq=3 ttl=64 time=0.337 ms

I can read it using readtable:

511×9 table
             Var1              Var2      Var3         Var4             Var5                 Var6             Var7            Var8          Var9 
    _______________________    ____    _________    ________    __________________    ________________    __________    ______________    ______
    {'[1707403470.450935]'}     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq=1'  }    {'ttl=64'}    {'time=0.378'}    {'ms'}
    {'[1707403471.452695]'}     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq=2'  }    {'ttl=64'}    {'time=0.248'}    {'ms'}
    {'[1707403472.482987]'}     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq=3'  }    {'ttl=64'}    {'time=0.337'}    {'ms'}

How can I extract the timestamps from Var1 and the times from Var8? I think I should be using cellfun, but I don't know how to.

4 个评论
显示 2更早的评论隐藏 2更早的评论

dormant 2024-2-29

Thanks. I was late back to check. Sometimes my work gets me distracted.

Walter Roberson 2024-2-29

在 MATLAB Online 中打开

ping sometimes produces results such as

Request timeout for icmp_seq 2

In theory your code has to handle these as well.

请先登录，再进行评论。

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

Answer 1

Voss 2024-2-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2079986-reading-ping-output-using-readtable#answer_1405151

在 MATLAB Online 中打开

test_file.txt

Here's one way to get the timestamps and times directly out of the file (without using readtable):

format longg
filename = 'test_file.txt';
% show the file's contents, for reference
type(filename)
PING 172.17.102.60 (172.17.102.60) 56(84) bytes of data.
[1707403470.450935] 64 bytes from 172.17.102.60: icmp_seq=1 ttl=64 time=0.378 ms
[1707403471.452695] 64 bytes from 172.17.102.60: icmp_seq=2 ttl=64 time=0.248 ms
[1707403472.482987] 64 bytes from 172.17.102.60: icmp_seq=3 ttl=64 time=0.337 ms
% read and parse the file
C = regexp(fileread(filename),'\[([\d\.?]+)\].*?time=([\d\.?]+)','tokens');
data = str2double(vertcat(C{:}))
data = 3×2
1.0e+00 *

          1707403470.45093                     0.378
          1707403471.45269                     0.248
          1707403472.48299                     0.337
timestamps = datetime(data(:,1),'ConvertFrom','posix')
timestamps = 3×1 datetime array
   08-Feb-2024 14:44:30
   08-Feb-2024 14:44:31
   08-Feb-2024 14:44:32
times = data(:,2)
times = 3×1
                     0.378
                     0.248
                     0.337

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Stephen23 2024-2-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2079986-reading-ping-output-using-readtable#answer_1405216

编辑：Stephen23 2024-2-8

在 MATLAB Online 中打开

testping.txt

Here is an easy way to import all numeric data as numeric, and with minimal post-processing for the datestamp:

T = readtable("testping.txt", 'Delimiter',[" ","=","]","["], "LeadingDelimitersRule","ignore", "MultipleDelimsAsOne",true)
T = 3×12 table
       Var1       Var2      Var3         Var4             Var5               Var6        Var7     Var8      Var9     Var10      Var11    Var12 
    __________    ____    _________    ________    __________________    ____________    ____    _______    ____    ________    _____    ______

    1.7074e+09     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     1      {'ttl'}     64     {'time'}    0.378    {'ms'}
    1.7074e+09     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     2      {'ttl'}     64     {'time'}    0.248    {'ms'}
    1.7074e+09     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     3      {'ttl'}     64     {'time'}    0.337    {'ms'}
T.Var1 = datetime(T.Var1, "ConvertFrom","posixtime")
T = 3×12 table
            Var1            Var2      Var3         Var4             Var5               Var6        Var7     Var8      Var9     Var10      Var11    Var12 
    ____________________    ____    _________    ________    __________________    ____________    ____    _______    ____    ________    _____    ______

    08-Feb-2024 14:44:30     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     1      {'ttl'}     64     {'time'}    0.378    {'ms'}
    08-Feb-2024 14:44:31     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     2      {'ttl'}     64     {'time'}    0.248    {'ms'}
    08-Feb-2024 14:44:32     64     {'bytes'}    {'from'}    {'172.17.102.60:'}    {'icmp_seq'}     3      {'ttl'}     64     {'time'}    0.337    {'ms'}