Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Array & text file
Top Forums Shell Programming and Scripting Array & text file Post 302875697 by Akshay Hegde on Wednesday 20th of November 2013 06:25:54 AM
Old 11-20-2013
Try : for difference

Code:
awk '
NR==1 || p!=$1{
                  Arr[++j] = s ? s RS $0 : $0
              }
              {
                p=$1;s=$0
              }
           END{
                   Arr[j+1]=$0
                   for(i=1;i<=j;i++){
                                         split(Arr[i],S1,RS);split(Arr[i+1],S2,RS)
                                         start = i == 1? S1[1] : S1[2]
                                         end   = i == 1? S2[1] : S2[1]
                                         split(start,St,"[:, ]");split(end,Se,"[:, ]")
                                         print start,end,((Se[2]*3600)+(Se[3]*60)+Se[4])-((St[2]*3600)+(St[3]*60)+St[4]),"Sec"
                                    }   
              }
   ' file

OR
Code:
awk  '

function sec(val){
                      gsub(/^.*[[:space:]]|,.*/,x,val)
                      split(val,Ar,":")
                      return ((Ar[1]*3600)+(Ar[2]*60)+Ar[3])
                 }
FNR==1 || p != $1{
                  if(s){
                         print t,s, sec(s)-sec(t),"sec"
                       }
                        t = $0 
                 }
                 {
                        p=$1;s=$0
                 }
             END{
                     print t,s,sec(s)-sec(t),"sec"
                }
           
   ' file

for input in post #1
Code:
10 17:54:47,213 10 17:54:50,403 3 Sec
11 17:54:47,213 11 17:54:51,510 4 Sec
12 17:54:47,213 12 17:54:51,460 4 Sec
24 18:30:01,405 24 18:30:03,122 2 Sec

for input in post #4
Code:
10 17:54:47,213 10 17:54:50,403 3 Sec
11 17:54:47,213 11 17:54:51,510 4 Sec
12 17:54:47,213 12 17:54:51,460 4 Sec
24 18:30:01,405 24 18:30:04,213 3 Sec
25 18:30:01,406 25 18:30:04,214 3 Sec
26 18:30:01,406 26 18:30:04,202 3 Sec
29 18:30:01,407 29 18:30:04,223 3 Sec
31 18:30:01,407 31 18:30:04,153 3 Sec
40 21:19:31,946 40 21:19:34,388 3 Sec
41 21:19:31,946 41 21:19:34,388 3 Sec
42 21:19:31,947 42 21:19:34,376 3 Sec
45 21:19:31,947 45 21:19:34,395 3 Sec
46 21:19:31,947 46 21:19:35,188 4 Sec
56 21:49:32,076 56 21:49:34,958 2 Sec
57 21:49:32,076 57 21:49:34,959 2 Sec
58 21:49:32,076 58 21:49:34,946 2 Sec
59 21:49:32,077 59 21:49:35,476 3 Sec
61 21:49:32,077 61 21:49:34,900 2 Sec
8 17:54:47,213 8 17:54:55,803 8 Sec
9 17:54:47,213 9 17:54:55,869 8 Sec

Last edited by Akshay Hegde; 11-20-2013 at 09:08 AM.. Reason: Some more code
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Overwrite & Delete in Text File

Dear All, I have text file like this: Header Record 1 Record 2 ....... Record n Tail This line of code : awk '{ if ( NR == 1 ) { head=substr($0,1,300);} else { last = substr($0,1,300);}END{printf "Header is : %-300s Trailer is : %-300s\n", head, last}' filename converted Header... (11 Replies)
Discussion started by: 33junaid
11 Replies

2. Shell Programming and Scripting

input text from file into 2d array

Hi all I have a little brainscratcher here. I want to draw a pie chart from data in a text file. The drawing of the graph works fine, if I insert the data manually into a 2d array. Now I want to pull the data from a text file (which was created using a uniq -c command) see sample below.... (2 Replies)
Discussion started by: pietie
2 Replies

3. Shell Programming and Scripting

Advanced Search & Delete Text File

I have a file in which email messages are stored in. Every email is separated by by a ^Z character (Control-Z). I need to extract all emails after the 65,00th one to another file and delete them from the original file. Any suggests on accomplishing this? (2 Replies)
Discussion started by: maxcell
2 Replies

4. Shell Programming and Scripting

Pipe text from a file into an array

Hi Guys I have a question about filling up an array I have a file called USER_FILE.txt it contains the following: Real Name:Thomas A Username:THOMAS_A Real Name:Thomas B Username:THOMAS_B Real Name:Thomas C Username:THOMAS_C Real Name:Thomas D Username:THOMAS_D Real Name:Thomas E... (8 Replies)
Discussion started by: grahambo2005
8 Replies

5. Shell Programming and Scripting

Parse text file in shell & store to variable

Hi, I need to parse a simple text file like below and store the word that starts with BR* to a variable say $BRno. I need to do this in sh script. NOTE: the length of the numbers following BR is in constant. And there is only 1 BRXXX in a file at a given time. .txt file: BR276828... (1 Reply)
Discussion started by: script2010
1 Replies

6. Shell Programming and Scripting

Text substitution & getting file name from url

hi, sorry if this seems trivial. i have a file url.txt which consists of a list of urls (it was supposed to be my wget -i file). however, since the server from which i am trying to download uses redirect, wget dows not remeber the filename of ther original url will save to a file name which is... (3 Replies)
Discussion started by: texttoolong
3 Replies

7. Shell Programming and Scripting

Search & Replacing text within a file

Hi all! I'm a newbie and I'm writing a script which will ask a user for data to search. I will then search for this data using grep and displaying this data back to the screen for the user to see. The user will then enter new data to replace the data searched. Now how do I replace this data... (4 Replies)
Discussion started by: macastor
4 Replies

8. Shell Programming and Scripting

Efficient population of array from text file

Hi, I am trying to populate an array with data from a text file. I have a working method using awk but it is too slow and inefficent. See below. The text file has 70,000 lines. As awk is a line editor it reads each line of the file until it gets to the required line and then processes it.... (3 Replies)
Discussion started by: carlr
3 Replies

9. Shell Programming and Scripting

Reading columns from a text file and to make an array for each column

Hi, I am not so familiar with bash scripting and would appreciate your help here. I have a text file 'input.txt' like this: 2 3 4 5 6 7 8 9 10 I want to store each column in an array like this a ={2 5 8}, b={3 6 9}, c={4 7 10} so that i can access any element, e.g b=6 for the later use. (1 Reply)
Discussion started by: Asif Siddique
1 Replies

10. Shell Programming and Scripting

Efficient way to search array in text file by awk

I have one array SPLNO with approx 10k numbers.Now i want to search the subscriber number from MDN.TXT file (containing approx 1.5 lac record)from the array.if subscriber number found in array it will perform below operation.my issue is that it's taking more time because for one number it's search... (6 Replies)
Discussion started by: siramitsharma
6 Replies
All times are GMT -4. The time now is 01:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy