Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk matching script not working as expected
Top Forums Shell Programming and Scripting awk matching script not working as expected Post 303014837 by rdrtx1 on Wednesday 21st of March 2018 04:48:08 PM
Old 03-21-2018
Code:
#!usr/bin/awk

{
  day=$1
  split($2, t, ".")
  x=day " " t[1]
  ("date --date=\""x"\" +%s") | getline seconds
  close("date --date=\""x"\" +%s")

  t[3]=seconds"."t[2]
  records[t[3]]=$0
}
 END {
    for (record in records) {
       #min=(0 + "INF")
       lmin=0
       for (others in records) {
          # skip myself
          if (others == record) continue
             difference=(others - record) - (5 * 60)
             if (difference < 0) difference=-difference
             if (!lmin++) min=difference + 1
             if (difference < min) {
                min=difference
                matchfor[record]=records[others]
             }
       }
       if (min > (60*2)) {
          print records[record], "NA NA"
       } else {
          sub("farads", " ", matchfor[record])
          print records[record], matchfor[record]
       }
   }
}

Last edited by rdrtx1; 03-21-2018 at 06:17 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

which not working as expected

Hello. Consider the following magic words: # ls `which adduser` ls: /usr/sbin/adduser: No such file or directory # Hmmm... Then: # ls /usr/sbin/adduser /usr/sbin/adduser # Now what? Unforunately this little sniippet is used in my debian woody server's mysql pre install script.... (2 Replies)
Discussion started by: osee
2 Replies

2. Shell Programming and Scripting

awk not working as expected with BIG files ...

I am facing some strange problem. I know, there is only one record in a file 'test.txt' which starts with 'X' I ensure that with following command, awk /^X/ test.txt | wc -l This gives me output = '1'. Now I take out this record out of the file, as follows : awk /^X/ test.txt >... (1 Reply)
Discussion started by: videsh77
1 Replies

3. Shell Programming and Scripting

Var substitution in awk - not working as expected

countA=`awk '/X/''{print substr($0,38,1)}' fName | wc -l` countB=`wc -l fName | awk '{print int($1)}'` echo > temp ratio=`awk -va=$countA -vc=$countB '{printf "%.4f", a/c}' temp` After running script for above I am getting an error as : awk: 0602-533 Cannot find or open file -vc=25. The... (3 Replies)
Discussion started by: videsh77
3 Replies

4. Shell Programming and Scripting

bash variable (set via awk+sed) not working as expected

Hi! Been working on a script and I've been having a problem. I've finally narrowed it down to this variable I'm setting: servername=$(awk -v FS=\/ '{ print $7 } blah.txt | sed 's\/./-/g' | awk -v FS=\- '{print $1}')" This will essentially pare down a line like this: ... (7 Replies)
Discussion started by: creativedynamo
7 Replies

5. Shell Programming and Scripting

Script not working as expected

Hi, I have prepared a script and trying to execute it but not getting expected output. Could you please help and advise what is going wrong. "If else" part in below script is not working basically. I am running it on HP-UX. for i in slpd puma sfmdb do echo "******\t$i\t*******" echo... (10 Replies)
Discussion started by: sv0081493
10 Replies

6. Shell Programming and Scripting

awk not working as expected in script

Dear all, I had script which used to work, but recently it is not working as expected. I have command line in my shell script to choose the following format from the output_elog and perform some task afterwards on As you see, I want all numbers in foramt following RED mark except for... (12 Replies)
Discussion started by: emily
12 Replies

7. Shell Programming and Scripting

awk command not working as expected

Following one line of awk code removes first 3 characters from each line but when I run the same code on another linux platform it doesn't work and only prints blank lines for each record. Can anyone please explain why this doesn't work? (31 Replies)
Discussion started by: later_troy
31 Replies

8. Shell Programming and Scripting

awk gsub not working as expected

Hi Experts, Need your kind help with gsub awk. Below is my pattern:"exec=1_host_cnt=100_dup=4_NameTag=targetSrv_500.csv","'20171122112948"," 100"," 1"," 1"," 4","400","","", " aac sample exec ""hostname=XXXXX commandline='timeout 10 openssl speed -multi 2 ; exit 0'"" ","-1","-1","1","... (6 Replies)
Discussion started by: pradyumnajpn10
6 Replies

9. UNIX for Beginners Questions & Answers

Passing Arguments to shell script from file is not working as expected.

Hi All, I have below simple shell script in cloudera quick start vm cenos 6 which copy file from source to destination. # file_copy.sh source_dir = ${source_dir} target = ${target_dir} cp source_dir target and my parameter file is like below #parameter_file.txt source_dir =... (4 Replies)
Discussion started by: Narasimhasss
4 Replies

10. UNIX for Beginners Questions & Answers

Why this script is not working as 'expected' when doing ssh with while read ... really confused?

Hi, I have a script below that is running ssh <host> <command> on some servers. Below is more or less the script. I have to modify it somehow to get rid of the 'confidential' hostnames check_log.bash #!/bin/bash # myPID=$$ parse_log () { sub="parse_log" host=${1} ... (2 Replies)
Discussion started by: newbie_01
2 Replies

LEARN ABOUT DEBIAN

ubuntu-upload-permission

ubuntu-upload-permission(1)				      General Commands Manual				       ubuntu-upload-permission(1)

NAME

       ubuntu-upload-permission - Query upload rights and (optionally) list the people and teams with upload rights for a package

SYNOPSIS

       ubuntu-upload-permission [options] package

DESCRIPTION

       ubuntu-upload-permission checks if the user has upload permissions for package.	If the --list-uploaders option is provided, all the people
       and teams that do have upload rights for package will be listed.

OPTIONS

       -r RELEASE, --release=RELEASE
	      Query permissions in RELEASE.  Default: current development release.

       -a, --list-uploaders
	      List all the people and teams who have upload rights for package.

       -t, --list-team-members
	      List all the members of every team with rights. (Implies --list-uploaders)

       -h, --help
	      Display a help message and exit

EXIT STATUS

       0      You have the necessary upload rights.

       1      You don't have the necessary upload rights.

       2      There was an error.

AUTHORS

       ubuntu-upload-permission and this manpage were written by Stefano Rivera <stefanor@ubuntu.com>.

       Both are released under the terms of the ISC License.

ubuntu-dev-tools						   November 2011				       ubuntu-upload-permission(1)
All times are GMT -4. The time now is 08:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy