Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk- comparing fields from the same column, finding discontinuities.
Top Forums Shell Programming and Scripting awk- comparing fields from the same column, finding discontinuities. Post 302513800 by acsg on Thursday 14th of April 2011 05:31:34 AM
Old 04-14-2011
Quote:
Originally Posted by |UVI|
Code:
cat input.txt | awk 'BEGIN{ 
  while (getline  > 0){
    if ( NR > 1 ){
      C1 = $1 
      C2 = $2

      if ( P1 == C1 && P2 != C2){
        if ( (P2+1)%16 != C2 )
          data_array[$1]++
      }
    }
    P1 = $1
    P2 = $2
  }
}

END{
  for (var in data_array)
    if ( data_array[var] > 1)
      print "Channel " var " : "  data_array[var] " discontinuities"
    else
      print "Channel " var " : "  data_array[var] " discontinuity"
}'

now should be works

 ---------- Post updated at 04:20 AM ---------- Previous update was at 03:58 AM ----------

using this the program prints also channel with 0 discontinuities Smilie

Code:
cat input.txt | awk 'BEGIN{

Code:
 
  while (getline  > 0 && NF > 0){
    data_array[$1]+=0
    if ( NR > 1 ){
      C1 = $1 
      C2 = $2

        if ( P1 == C1 && P2 != C2){
        if ( (P2+1)%16 != C2 )
          data_array[$1]++
      }
    }
    P1 = $1
    P2 = $2
  }
}

END{ 
  for (var in data_array)
    if ( data_array[var] = 1)
      print "Channel " var " : "  data_array[var] " discontinuity"
    else
      print "Channel " var " : "  data_array[var] " discontinuities"
}'


Smilie Thank you so much!! You were extremely helpful.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding the total of a column using awk

Here is my file name countries USSR 8650 262 Asia Canada 3852 24 North America China 3692 866 Asia USA 3615 219 North America Brazil 3286 116 South America India 1269 637 Asia Argentina 1072 ... (8 Replies)
Discussion started by: ironhead3fan
8 Replies

2. Shell Programming and Scripting

finding greatest value in a column using awk from iostat output in linux

Friends, . On linux i have to run iostat command and in each iteration have to print the greatest value in each column. e.g iostat -dt -kx 2 2 | awk ' !/sd/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' 4.38 0.00 0.00 0.00 What i would like to print is only the... (3 Replies)
Discussion started by: achak01
3 Replies

3. Programming

comparing two fields from two different files in AWK

Hi, I have two files formatted as following: File 1: (user_num_ID , realID) (the NR here is 41671) 1 cust_034_60 2 cust_80_91 3 cust_406_4 .. .. File 2: (realID , clusterNumber) (total NR here is 1000) cust_034_60 2 cust_406_4 3 .. .. (11 Replies)
Discussion started by: amarn
11 Replies

4. Shell Programming and Scripting

Comparing two csv file fields using awk script

Hi All, I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the same record in both files.Here is an example on what I need. File1.csv: RAJAK|ACTIVE|1... (2 Replies)
Discussion started by: rajak.net
2 Replies

5. UNIX for Dummies Questions & Answers

Compare values of fields from same column with awk

Hi all ! If there is only one single value in a column (e.g. column 1 below), then return this value in the same output column. If there are several values in the same column (e.g. column 2 below), then return the different values separated by "," in the output. pipe-separated input: ... (11 Replies)
Discussion started by: lucasvs
11 Replies

6. UNIX for Dummies Questions & Answers

Comparing multiple fields from 2 files uing awk

Hi I have 2 files as below File 1 Chr Start End chr1 120 130 chr1 140 150 chr2 130 140 File2 Chr Start End Value chr1 121 128 ABC chr1 144 149 XYZ chr2 120 129 PQR I would like to compare these files using awk; specifically if column 1 of file1 is equal to column 1 of file2... (7 Replies)
Discussion started by: sshetty
7 Replies

7. Shell Programming and Scripting

Join fields comparing 4 fields using awk

Hi All, I am looking for an awk script to do the following Join the fields together only if the first 4 fields are same. Can it be done with join function in awk?? a,b,c,d,8,,, a,b,c,d,,7,, a,b,c,d,,,9, a,b,p,e,8,,, a.b,p,e,,9,, a,b,p,z,,,,9 a,b,p,z,,8,, desired output: ... (1 Reply)
Discussion started by: aksijain
1 Replies

8. Shell Programming and Scripting

Finding out the common lines in two files using 4 fields with the help of awk and UNIX

Dear All, I have 2 files. If field 1, 2, 4 and 5 matches in both file1 and file2, I want to print the whole line of file1 and file2 one after another in my output file. File1: sc2/80 20 . A T 86 F=5;U=4 sc2/60 55 . G T ... (1 Reply)
Discussion started by: NamS
1 Replies

9. Shell Programming and Scripting

UNIX append field with comparing fields from multiple column

I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5. i.e from ANG SJ,0,B,LC22,LC22(0) BAT... (2 Replies)
Discussion started by: nike27
2 Replies

10. Shell Programming and Scripting

Append data with substring of nth column fields using awk

Hi guys, I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value. My code: awk... (4 Replies)
Discussion started by: null7
4 Replies

LEARN ABOUT DEBIAN

dbfdump

SHAPELIB(1)							   User Commands						       SHAPELIB(1)

NAME

       dbfdump - dump xBase DBF files as text

SYNOPSIS

       dbfdump [-h] [-m] [-r] file

DESCRIPTION

       Dumps  the contents of file to standard output.	The first line contains the field names appearing in file, and each of the following lines
       contains the field values of a record.  Field names and values are padded by spaces to their field widths.  Empty fields are printed as the
       string "(NULL)".

OPTIONS

       -h     Prints the column field definitions before other output.	Each field definition consists of a line of the form

	      Field: index, Type=type, Title=`name', Width=width, Decimals=precision

	      where  index  is the zero offset column number of the field; the type indicates the datatype of the field value and is either "Inte-
	      ger", "Real" or "String"; name is the field's name; width is the number of bytes reserved for the field's value;	and  precision	is
	      the number of decimal places of precision for "Real" type fields, and is zero for "Integer" and "String" type fields.

       -m     Prints  each  record in multiline format separated by empty lines.  The first line of a record gives the number of the record in the
	      form

	      Records: record_index

	      where record_index is the zero offset number of the record in the file, and then each field of the record appears on its own line in
	      the format

	      name: value

       -r     Prints the exact bytes occurring in file for field values and suppresses printing "(NULL)" for empty values.

EXIT STATUS

       0      Successful program execution.

       1      Missing file argument.

       2      Failed to open file.

       3      There are no fields in file.

DIAGNOSTICS

       The following diagnostics may be issued on stdout:

       DBFOpen(file,"r") failed.

       There are no fields in this table!

AUTHORS

       Frank  Warmerdam (warmerdam@pobox.com) is the maintainer of the shapelib shapefile library.  Joonas Pihlaja (jpihlaja@cc.helsinki.fi) wrote
       this man page.

BUGS

       Unless the -r option is given, values in numeric fields that overflow the int or double types of the C language	are  printed  as  plus	or
       minus a huge number.  For integer fields the huge value is HUGE_VALL from <stdlib.h> and for real fields it is HUGE_VALF.

SEE ALSO

       dbf_dump(1), dbfcreate(1), dbfadd(1), shpadd(1), shpcreate(1), shpdump(1), shprewind(1)

shapelib							   OCTOBER 2004 						       SHAPELIB(1)
All times are GMT -4. The time now is 08:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy