Date: Thu, 22 Sep 2016 14:42:14 +0300 From: =?iso-8859-9?Q?Yavuz_Ma=FElak?= <yavuz.maslak@netiletisim.net> To: "'Miroslav Lachman'" <000.fbsd@quip.cz>, <freebsd-pf@freebsd.org> Subject: RE: how to convert pf-table into csv Message-ID: <01d601d214c6$5ce99de0$16bcd9a0$@netiletisim.net> In-Reply-To: <57E3A52B.3020505@quip.cz> References: <00bf01d20ade$5bc68500$13538f00$@netiletisim.net> <57E3A52B.3020505@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
If i use awk, could you give a code an example ?
For instance; =20
10.10.240.77
Cleared: Thu Sep 22 13:22:50 2016
In/Block: [ Packets: 0 Bytes: 0
]
In/Pass: [ Packets: 68000 Bytes: 9899430
]
Out/Block: [ Packets: 0 Bytes: 0
]
Out/Pass: [ Packets: 54731 Bytes: 72930039
]
i want to convert this as below
10.10.240.77,In/Pass: Bytes: 9899430, Out/Pass: Bytes: 72930039
-----Original Message-----
From: Miroslav Lachman [mailto:000.fbsd@quip.cz]=20
Sent: Thursday, September 22, 2016 12:32 PM
To: Yavuz Ma=FElak <yavuz.maslak@netiletisim.net>; =
freebsd-pf@freebsd.org
Subject: Re: how to convert pf-table into csv
Yavuz Ma=FElak wrote on 09/09/2016 23:08:
> =DD have a dynamic pf-table as below;
>
>
>
>
>
> 10.10.231.230
>
> Cleared: Fri Sep 9 22:55:53 2016
>
> In/Block: [ Packets: 0 Bytes: 0
> ]
>
> In/Pass: [ Packets: 33455 Bytes: 2796398
> ]
>
> Out/Block: [ Packets: 0 Bytes: 0
> ]
>
> Out/Pass: [ Packets: 3068 Bytes: 4350822
> ]
>
> 10.10.231.234
>
> Cleared: Fri Sep 9 23:33:18 2016
>
> In/Block: [ Packets: 0 Bytes: 0
> ]
>
> In/Pass: [ Packets: 26585 Bytes: 2262193
> ]
>
> Out/Block: [ Packets: 0 Bytes: 0
> ]
>
> Out/Pass: [ Packets: 11709 Bytes: 16738469
> ]
>
>
>
>
>
> =DD want to convert it to csv format something like that ;
>
>
>
> Let it begin an ip address and go on its statistics ;
>
> 10.10.231.234, Cleared: Fri Sep 9 23:33:18 2016, In/Pass: [
> Packets: 26585 Bytes: 2262193
>
>
>
> How can i do that ?
You need to write some parser of this output in scripting language you =
are
familiar with. You can use Perl, Python, Ruby, PHP etc. If you need to =
write
it with base utils only you can use awk.
Miroslav Lachman
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?01d601d214c6$5ce99de0$16bcd9a0$>