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-dev-tools

ubuntu-dev-tools(5)						File Formats Manual					       ubuntu-dev-tools(5)

NAME

       ubuntu-dev-tools - Configuration for the ubuntu-dev-tools package.

DESCRIPTION

       The  ubuntu-dev-tools  package  is  similar in scope to the devscripts(1) package, providing a collection of scripts which may be of use to
       Ubuntu and Debian developers or others wishing to build Debian packages.

       Some of these scripts have options which may be configured  on  a  system-wide  and  per-user  basis.   These  options  are  configured	in
       devscripts.conf(5).

       All variables are described in the script's manpages. Package-wide variables begin with "UBUNTUTOOLS" and are listed below.

       Every script which reads the configuration files can be forced to ignore them by using the --no-conf command-line option.

ENVIRONMENT

       All ubuntu-dev-tools configuration variables can be set (and overridden) by setting them in the environment (unlike devscripts).

       In addition, several scripts use the following environment variables:

       UBUMAIL
	      Overrides  DEBEMAIL  and	DEBFULLNAME  when  the	target	is  clearly  Ubuntu.   Can  either  contain an e-mail address or Full Name
	      <email@example.org>.

       DEBEMAIL, DEBFULLNAME
	      As in devscripts(1).

PACKAGE-WIDE VARIABLES
       The currently recognised package-wide variables are:

       UBUNTUTOOLS_BUILDER
	      This specifies the preferred test-builder, one of pbuilder (default), sbuild, pbuilder-dist.

       UBUNTUTOOLS_DEBIAN_MIRROR
	      The preferred Debian archive mirror.  Should be of the form http://ftp.debian.org/debian (no trailing slash).  If not specified, the
	      master will be used.

       UBUNTUTOOLS_DEBSEC_MIRROR
	      The  preferred Debian security archive mirror.  Should be of the form http://security.debian.org (no trailing slash).  If not speci-
	      fied, the master will be used.

       UBUNTUTOOLS_UBUNTU_MIRROR
	      The preferred Ubuntu archive mirror.  Should be of the form http://archive.ubuntu.com/ubuntu (no trailing slash).  If not specified,
	      the master will be used.

       UBUNTUTOOLS_UBUNTU_PORTS_MIRROR
	      The preferred Ubuntu archive mirror.  Should be of the form http://ports.ubuntu.com (no trailing slash).	If not specified, the mas-
	      ter will be used.

       UBUNTUTOOLS_LPINSTANCE
	      The launchpad instance to communicate with. e.g. production (default) or staging.

       UBUNTUTOOLS_MIRROR_FALLBACK
	      Whether or not to fall-back to the master archive mirror.  This is usually the desired behaviour, as mirrors can	lag  the  masters.
	      If on a private network with only a local mirror, you may want to set this to no.  One of yes (default) or no.

       UBUNTUTOOLS_UPDATE_BUILDER
	      Whether or not to update the test-builder before each test build.  One of yes or no (default).

       UBUNTUTOOLS_WORKDIR
	      The directory to use for preparing source packages etc.  When unset, defaults to a directory in /tmp/ named after the script.

SEE ALSO

       devscripts(1), devscripts.conf(5)

AUTHORS

       This manpage was written by Stefano Rivera <stefanor@ubuntu.com>.

ubuntu-dev-tools						 December 19 2010					       ubuntu-dev-tools(5)
All times are GMT -4. The time now is 08:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy