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 302893234 by summer_cherry on Tuesday 18th of March 2014 04:40:05 AM
Old 03-18-2014
python
Code:
d={}
td={}
with open("a.txt") as file:
 for line in file:
  line=line.replace("\n","")
  items=line.split(" ")
  a=[int(i) for i in items[0].split(":")]
  t=a[0]*3600+a[1]*60+a[2]
  if items[-1]=='OFFLINE':
   d[items[-2]]=t
  elif items[-1]=='ONLINE' and items[-2] in d:
   gap = t - d[items[-2]]
   if gap<120:
    td[items[-2]]=1
    
for i in d:
 if i not in td:
   print(d[i]//3600,":",(d[i]%3600)//60,":",(d[i]%3600)%60,' ',i,' OFFLINE',sep="")

 

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 OSF1

xmlistreplacepositions

XmListReplacePositions(3X)												XmListReplacePositions(3X)

NAME

       XmListReplacePositions - A List function that replaces items in a list based on position

SYNOPSIS

       #include <Xm/List.h>

       void XmListReplacePositions (widget, position_list, item_list, item_count)
	       Widget widget;
	       int *position_list;
	       XmString *item_list;
	       int item_count;

DESCRIPTION

       XmListReplacePositions  replaces  noncontiguous items in a list.  The item at each position specified in position_list is replaced with the
       corresponding entry in item_list. When the items are inserted into the list, they are compared with the current XmNselectedItems list.  Any
       of  the	new  items  that  match  items	on  the selected list appears selected.  A warning message is displayed if a specified position is
       invalid; that is, the value is 0, a negative integer, or a number greater than the number of items in the list.	Specifies the  ID  of  the
       List  widget.   Specifies an array of the positions of items to be replaced.  The position of the first item in the list is 1; the position
       of the second item is 2; and so on.  Specifies an array of the replacement items.  Specifies the number of elements  in	position_list  and
       item_list. This number must be non-negative.

       For a complete definition of List and its associated resources, see XmList(3X).

SEE ALSO

       XmList(3X)

															XmListReplacePositions(3X)
All times are GMT -4. The time now is 09:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy