Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Printing from file with awk
Top Forums Shell Programming and Scripting Printing from file with awk Post 302893262 by Klashxx on Tuesday 18th of March 2014 08:10:40 AM
Old 03-18-2014
I would choose another python approach by using datetime calculation facilities:
Code:
#cat filter.py
#!/usr/bin/python

import sys
import datetime

first_offline = {}
with  open(sys.argv[1],'r') as f:
    for line in f:
        (dt, host, status) = line.split()
        dt = datetime.datetime.strptime(dt,"%H:%M:%S")
        if status == 'OFFLINE' and host not in first_offline:
            first_offline[host] = (dt,line)
        elif status == 'ONLINE' and host in first_offline:
            dif_time = abs(dt - first_offline[host][0])
            if dif_time.seconds + dif_time.days * 24 * 3600 < 120:
                del first_offline[host]

if first_offline[host][1] == line:
    del first_offline[host]

for line in first_offline.values():
    print line[1],

Usage:
Code:
./filter.py infile

This User Gave Thanks to Klashxx For This Post:
keenboy100
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK - printing certain fields when field order changes in data file

I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this: sec;src;dst;proto 421;10.10.10.1;10.10.10.2;tcp 426;10.10.10.3;10.10.10.4;udp 442;10.10.10.5;10.10.10.6;tcp sec;src;fac;dst;proto 521;10.10.10.1;ab;10.10.10.2;tcp... (3 Replies)
Discussion started by: eric4
3 Replies

2. Shell Programming and Scripting

need help with awk in printing the fields in a file

hi all i get a file from a server and i do not know how many fields that file will contain. i need to cut from the second column of the file to the last, irrespective of how many fields are there. is there any way to make the awk command dynamic for fetching from the second to the last... (4 Replies)
Discussion started by: sais
4 Replies

3. Shell Programming and Scripting

AWK printing

i have a file containing a line 123456 is it possible to use AWK to print it out to look like 1 2 3 4 5 6 (8 Replies)
Discussion started by: tomjones
8 Replies

4. UNIX for Dummies Questions & Answers

Printing File Contents Using AWK

I want to print the contents of a file from 2nd line to last but one line using the AWK command. I tried using the Shell Script,MyScript as fallows: MyScript: { if(NR>1) { if(NR<9) { print $0 } } } and used the commnd : awk -f MyScript Filename Note: Filename contains 9 lines text.... (0 Replies)
Discussion started by: ashok.g
0 Replies

5. Shell Programming and Scripting

awk printing only parts of file

I am afraid I don't understand awk well enough to do the following. I have a file with a bunch of select statements where the a line starts off with this pattern: "Last parsed SQL statement :", then continues with the select statement. At the first blank space I'd like it to stop, print that... (5 Replies)
Discussion started by: fwellers
5 Replies

6. Shell Programming and Scripting

awk - printing the passwd file

I've got a number of RHEL systems and I'm trying to use awk to read and format the output of /etc/passwd. But I'd like to display the host name of the system at the beginning of each line of output. I've got it working without the adding the host name in this script: #!/bin/bash ... (3 Replies)
Discussion started by: westmoreland
3 Replies

7. Shell Programming and Scripting

Awk: Comparing arguments with in line values of file and printing the result

I need to develop a script where I will take two date arguments as parameter date1 and date2 which will in format YYYYMM. Below is the input file say sample.txt. sample.txt will have certain blocks starting with P1. Each block will have a value 118,1:TIMESTAMP. I need to compare the... (7 Replies)
Discussion started by: garvit184
7 Replies

8. Shell Programming and Scripting

[awk] printing value of a variable assignment from a file

Heyas Me try to print only the value of a (specific) variable assignment from a file. What i get (1): :) tui $ bin/tui-conf-get ~/.tui_rc TUI_THEME dot-blue "" "$TUI_DIR_INSTALL_ROOT/usr" "$TUI_DIR_INSTALL_ROOT/etc/tui" "$TUI_PREFIX/share/doc/tui" "$TUI_PREFIX/share/tui"... (2 Replies)
Discussion started by: sea
2 Replies

9. Shell Programming and Scripting

Printing string from last field of the nth line of file to start (or end) of each line (awk I think)

My file (the output of an experiment) starts off looking like this, _____________________________________________________________ Subjects incorporated to date: 001 Data file started on machine PKSHS260-05CP ********************************************************************** Subject 1,... (9 Replies)
Discussion started by: samonl
9 Replies

10. UNIX for Beginners Questions & Answers

awk to clean up input file, printing both fields

In the f1 file below I am trying to clean it up removing lines the have _tn_ in them. Next, removing the characters in $2 before the ninth /. Then I remove the ID_(digit- always 4). Finally, the charcters after and including the first _. It is curently doing most of it but the cut is removing $1... (5 Replies)
Discussion started by: cmccabe
5 Replies

LEARN ABOUT LINUX

wxdatepickerctrl

wxDatePickerCtrl(3erl)					     Erlang Module Definition					    wxDatePickerCtrl(3erl)

NAME

       wxDatePickerCtrl - See external documentation: wxDatePickerCtrl.

DESCRIPTION

       See external documentation: wxDatePickerCtrl .

       This class is derived (and can use functions) from:
       wxPickerBase
       wxControl
       wxWindow
       wxEvtHandler

DATA TYPES

	 wxDatePickerCtrl() :

	   An  object  reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc
	   or distributed for use on other nodes.

EXPORTS

       new() -> wxDatePickerCtrl()

	      See external documentation .

       new(Parent::wxWindow() (see module wxWindow), Id::integer()) -> wxDatePickerCtrl()

	      Equivalent to new(Parent, Id, []) .

       new(Parent::wxWindow() (see module wxWindow), Id::integer(), Options::[Option]) -> wxDatePickerCtrl()

	      Types  Option = {date, datetime() (see module wx)} | {pos, {X::integer(), Y::integer()}} | {size,  {W::integer(),  H::integer()}}  |
		     {style, integer()} | {validator, wx() (see module wx)}

	      See external documentation .

       getRange(This::wxDatePickerCtrl(), Dt1::datetime() (see module wx), Dt2::datetime() (see module wx)) -> bool()

	      See external documentation .

       getValue(This::wxDatePickerCtrl()) -> datetime() (see module wx)

	      See external documentation .

       setRange(This::wxDatePickerCtrl(), Dt1::datetime() (see module wx), Dt2::datetime() (see module wx)) -> ok

	      See external documentation .

       setValue(This::wxDatePickerCtrl(), Date::datetime() (see module wx)) -> ok

	      See external documentation .

       destroy(This::wxDatePickerCtrl()) -> ok

	      Destroys this object, do not use object again

AUTHORS

       <>

								  wxErlang 0.98.9					    wxDatePickerCtrl(3erl)
All times are GMT -4. The time now is 03:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy