awk query Post: 302892239

Sponsored Content

Top Forums Shell Programming and Scripting awk query Post 302892239 by nua7 on Tuesday 11th of March 2014 03:26:43 PM

03-11-2014

Registered User

awk query

Hi,
I have a sample file in the following format.

Code:

000013560240|000013560240|001|P|155|99396|0||SS00325665|
000013560240|000013560240|002|P|17|99000|0||SS00325665|
000013560240|000013560240|002|F|-17|99000|0|R|SS00325665|
000013560240|000013560240|003|P|20|82270|0||SS00325665|
000013560240|000013560240|004|F|17|99000|0||SS00325665|
000012817460|000012817460|001|P|129.98|V2202|0||SS00425539|
000012817460|000012817460|001|F|-129.98|V2202|0|R|SS00425539|
000016132850|000016132850|001|P|59.99|E0607|0||SS00154667|
000016132850|000016132850|001|F|-59.99|E0607|0|R|SS00154667|
000016132850|000016132850|002|P|24|E1399|0||SS00154667|
000016132850|000016132850|002|F|-24|E1399|0|R|SS00154667|
000016132850|000016132850|003|F|59.99|E0607|0||SS00154667|
000016132850|000016132850|004|F|24|E1399|0||SS00154667|

I need the output file as below :

Code:

000013560240|000013560240|001|P|155|99396|0||SS00325665|
000013560240|000013560240|003|P|20|82270|0||SS00325665|
000013560240|000013560240|004|F|17|99000|0||SS00325665|
000016132850|000016132850|003|F|59.99|E0607|0||SS00154667|
000016132850|000016132850|004|F|24|E1399|0||SS00154667|

The logic is tom compare fields 3 and 5 and if field 5 has corresponding negative value which matched to the positive value based on field 3 , those records should be ignored.

This can be done in Perl using arrays but was wondering if this can be achieved through awk or sed or a shell script. Any help is appreciated.

nua7

View Public Profile for nua7

Find all posts by nua7

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Query In awk

Is it possible to have a pattern as RS in awk. For Example pl. go through the statement; " Account Serial Number: 88888888 TT00X000000XXXXXXXXXXXXX SS00X000000XX.000,XXXXXXXXXXXXXXXXXX0000XXXXXXX0000000000 WW00X0000000XX000000000000MMMMMMM MMMMMMM0000AA11110000000000000000000000000...

2. UNIX for Dummies Questions & Answers

Query in awk

file "batsmen" contains Bradman;Australia;52;6996 Gavaskar;India;124;10122 Sobers;West;Indies;93;8032 Border;Australia;109;8075 Miandad;Pakistan;97;7121 Gower;England;94;7023 Boycott;England;108;8114 My awk script contains awk '{FS=";"} {len=length($1)}; ...

3. UNIX for Dummies Questions & Answers

some query in awk

Hi , I want to assign a value to variable which will have size of the file that is we have following files for eg: ls -ltr -rw-rw-r-- 1 dsadmin dstage 34 Oct 29 12:14 some.txt -rw-rw-r-- 1 dsadmin dstage 0 Oct 29 14:52 eg.txt -rwxrwxr-x 1 dsadmin dstage 1453 Oct...

4. Shell Programming and Scripting

Awk Gsub Query

Hi, Can some one please explain the following line please throw some light on the ones marked in red awk '{print $9}' ${FTP_LOG} | awk -v start=${START_DATE} 'BEGIN { FS = "." } { old_line1=$0; gsub(/\-/,""); if ( $3 >= start ) print old_line1 }' | awk -v end=${END_DATE} 'BEGIN { FS="." } {...

5. Solaris

awk output query

Hi Everyone, When i issue command like ls -l | awk '/udtts/ {print $9}' =============================== I am getting output as udttsGEHLNAR.6864 udttsGEHLNAR.7921 udttsNARALAX.15415 udttsNARALAX.18016 But I want output after dot i.e like 6864 7921 15415 18016

6. Shell Programming and Scripting

sed or awk query

I have a set of multiple files out of which one i am showing below : A0120110124102329 BED. B01***DETALLADA 43984 The BO1 is the starting pattern of the second line. In the 2nd line in position 30,31,32 i need to replace 111, instead of 3...

7. Shell Programming and Scripting

AWK Query

i have a log file where in i have 3 columns a 11 test1 b 22 test2 in a script, i want to pass first column as an argument to awk so that i can get the second and third column respectively Example : If i pass ($1 i.e 'a' to an awk, the result should be 11 test1) i tried different awk...

8. Shell Programming and Scripting

awk query

Dear all, I find a shell script about awk command in the forum regarding "Find and replace duplicate column values in a row" In this thread, there is a command line as shown below to replace duplicate awk -F, '{for (i=1;i<=NF;i++){if (v++){b=$i;$i=""}};print $0} END { print "dups are"...

9. UNIX for Dummies Questions & Answers

Awk - query about arrays

Hello again, I have example config file with two arrays: tab1="name1 surname1" tab1="name2 surname2" tab1="name3 surname3" tab2="First" tab2="Second"and csv file: "aaaaa","surname1","name1","ddddd,eeeee","ffffff","ggggg","3","2012/02/22 12:25:21","2012/02/22...

10. UNIX for Beginners Questions & Answers

Query on awk

Hello, I am trying to find the RAM usage for one of the process from a group of servers. xx-Process name The command i used by logging to the individual server is as below ps aux | grep xx | awk '{sum=sum+$6}; END {print sum/1024 " MB"}' And the result is 0.824219 MB This...

LEARN ABOUT OPENSOLARIS

ale

ALE(1)																	    ALE(1)

NAME

       ale - a synthetic capture engine and renderer

SYNOPSIS

       ale [OPTIONS] original-frame [supplemental-frames ...] output-file

       ale [HELP OPTIONS]

       ale --version

DESCRIPTION

       ALE is a free software synthetic capture engine and renderer accepting, as input, a sequence of image frames, and producing, as output,
       rendered images, registration data, and 3D models (currently experimental).

EXAMPLES

       ale --hu
	   Print the help page on program usage.

       ale 001.ppm 002.ppm 003.ppm out.ppm
	   Render output file out.ppm from inputs 001.ppm, 002.ppm, and 003.ppm.

       ale --scale 2 001.ppm 002.ppm 003.ppm out.png
	   Render output file out.png at 2x scale.

       ale --perturb-upper=0 --trans-load=a.t --projective frame*.png out.png
	   Render output file out.png from inputs frame*.png, using projective transformations as described in the file a.t.

       ale --3dv 0 out.png --projective frame*.png null:
	   Render output file out.png from inputs frame*.png, using a 3D scene model to determine transformations.

       ale --visp last:sinc*lanc:6 sf:0 out/ .jpg in/*.jpg null:
	   Render a video stream from files in/*.jpg to the directory out/, stabilizing to the first frame, with a lanczos-windowed sinc filter.

USAGE

       ale is a wrapper script that calls the executable ale-bin after extracting exposure EXIF information from image files (when the exiftool
       utility is available) and converting from raw formats (when the dcraw utility is available).

       When ale-bin has been linked with ImageMagick, input and output files may be of any kind supported by ImageMagick. Otherwise, only PPM
       files can be read and written by ale-bin.

OPTIONS

       OPTIONS are summarized via built-in help pages (see HELP OPTIONS below). More detailed manuals describing options and internal algorithms
       are available for certain versions of ALE. See SEE ALSO below for more details on other manuals.

HELP OPTIONS

       A listing of available help options can be obtained by invoking ale --hu.

ENVIRONMENT

       The wrapper script ale recognizes the following environment variables:

       ALE_BIN
	   ALE executable to use.

       DCRAW
	   dcraw raw extraction tool to use.

       EXIF_UTILITY
	   EXIF extraction utility to use.

       ALE_COUNT_THREADS
	   Displays statistics on thread counts when set to a non-zero value.

       PAGER
	   Text pager to use (e.g., for displaying help pages).

SEE ALSO

       More detailed manuals for certain versions of ALE are distributed with source packages, and may also be available from:

       http://auricle.dyndns.org/ALE/manuals/

								    03/31/2009								    ALE(1)