Help me in awk or sed in UNIX Post: 302975038

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Help me in awk or sed in UNIX Post 302975038 by Skrynesaver on Tuesday 7th of June 2016 10:23:56 AM

Old

06-07-2016

Registered User

Similar logic in awk

Code:

$ awk -F\  '
{count[$1]++;
if ((count[$1]==2) && ($3~/\(/)){
   record[$1]=gensub(/([^ ]+ +[^ ]+ +[^ ]+ +[^ ]+)(.+)/,"\\1new\\2",1,record[$1]);
}
record[$1]=record[$1]"\n"$0;
}
END{for (id in record){print record[id];}}' tmp/tmp.dat

a@ a00 a00000 a00 a000000 a00 a0000 a0000 a00000000 a01
a@ a1 a2 a11 a22 a12 a13 a44 a45 a54 a65 a76 a77
a@ a1 a3 a6 a7 a9 a8 a2 a7 a8 a8 a9 a0

b@ b00 b00000 b00 b000000 b00 b0000 b0000 b00000000 b01
b@ b1 b2 b11 b22 b12 b13 b44 b45 b54 b65 b76 b77
b@ b1 b3 b6 b7 b9 b8 b2 b7 b8 b8 b9 b0

c@ c00 c00000 c00new c000000 c00 c0000 c0000 c00000000 c01
c@ c1 c( c11 c22 c12 c13 c44 c45 c54 c65 c76 c77
c@ c1 c3 c6 c7 c9 c8 c2 c7 c8 c8 c9 c0

d@ d00 d00000 d00 d000000 d00 d0000 d0000 d00000000 d01
d@ d1 d2 d11 d22 d12 d13 d44 d45 d54 d65 d76 d77
d@ d1 d3 d6 d7 d9 d8 d2 d7 d8 d8 d9 d0

Last edited by Skrynesaver; 06-07-2016 at 12:15 PM.. Reason: Remove debugging

Skrynesaver

View Public Profile for Skrynesaver

Find all posts by Skrynesaver

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sed in awk ? or nested awk ?

Hey all, Can I put sed command inside the awk action ?? If not then can i do grep in the awk action ?? For ex: awk '$1=="174" { ppid=($2) ; sed -n '/$ppid/p' tempfind.txt ; }' tempfind.txt Assume: 174 is string. Assume: tempfind.txt is used for awk and sed both. tempfind.txt...

2. UNIX for Advanced & Expert Users

unix awk/sed program

i need a sample unix awk/sed program to replace param3 in a file. i have sample file a.dat with the following format/length (week 8, sku 20, store 20 and qty 8). all store id's which end with _2 needs to be replaced with div id 2. all store id's which end with _1 needs to be replaced with div id...

3. Shell Programming and Scripting

help with sed or awk

I need to add a field at the beginning of each record in the file. The file is comma seperated. Can somebody throw some light. My record looks something like this I need to add 100 at the beginning of each record. o/p should be

4. UNIX for Dummies Questions & Answers

What should be precedence of using awk, sed, head and tail in UNIX?

Hi All, I am new to unix. In this forum some days back, I have read something like below: 1) Do not use perl if awk can do your work. 2) Do not use awk if sed can do your work. . . . I do not re-collect the whole thing. I think it is good to know the precedence of using these...

5. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

Hi, I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :- ./sample.sh: line...

6. Shell Programming and Scripting

Awk/sed help

Dear All, The row_eff_tmstp (4th field) and row_expr_tmstp(5th field) in below data represents. If row_expr_tmstp is less than row_eff_tmstp I should replace that as null. First record is header record. I/P ------ DD04 DD040001 DD040001 NO NO NONE ...

7. Shell Programming and Scripting

Join the line on delimiter using sed/awk in UNIX

I've input as , abcd| ef 123456| 78| 90 Desired output as, abcdef 1234567890 Anyone please give the solution.

8. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE...

9. How to Post in the The UNIX and Linux Forums

Help me in awk or sed in UNIX

I have a fixed length file that looks like a@ a00 a00000 a00 a000000 a00 a0000 a0000 a00000000 a01 a@ a1 a2 a11 a22 a12 a13 a44 a45 a54 a65 a76 a77 a@ a1 a3 a6 a7 a9 a8 a2 a7 a8 a8 a9 a0 b@ b00 b00000 b00...

10. UNIX for Beginners Questions & Answers

UNIX for learning sed/awk/grep..etc..

Greetings all, I am looking for a version of Linux that I can practice my scripting skills on. Currently, I support a massive system running on AIX. I want to do more with awk, sed, grep, and even perl. I am looking for something I can throw on a VM on my personal laptop and mess around with....

LEARN ABOUT DEBIAN

spbstf

spbstf.f(3)							      LAPACK							       spbstf.f(3)

NAME

       spbstf.f -

SYNOPSIS

   Functions/Subroutines
       subroutine spbstf (UPLO, N, KD, AB, LDAB, INFO)
	   SPBSTF

Function/Subroutine Documentation
   subroutine spbstf (characterUPLO, integerN, integerKD, real, dimension( ldab, * )AB, integerLDAB, integerINFO)
       SPBSTF

       Purpose:

	    SPBSTF computes a split Cholesky factorization of a real
	    symmetric positive definite band matrix A.

	    This routine is designed to be used in conjunction with SSBGST.

	    The factorization has the form  A = S**T*S	where S is a band matrix
	    of the same bandwidth as A and the following structure:

	      S = ( U	 )
		  ( M  L )

	    where U is upper triangular of order m = (n+kd)/2, and L is lower
	    triangular of order n-m.

       Parameters:
	   UPLO

		     UPLO is CHARACTER*1
		     = 'U':  Upper triangle of A is stored;
		     = 'L':  Lower triangle of A is stored.

	   N

		     N is INTEGER
		     The order of the matrix A.  N >= 0.

	   KD

		     KD is INTEGER
		     The number of superdiagonals of the matrix A if UPLO = 'U',
		     or the number of subdiagonals if UPLO = 'L'.  KD >= 0.

	   AB

		     AB is REAL array, dimension (LDAB,N)
		     On entry, the upper or lower triangle of the symmetric band
		     matrix A, stored in the first kd+1 rows of the array.  The
		     j-th column of A is stored in the j-th column of the array AB
		     as follows:
		     if UPLO = 'U', AB(kd+1+i-j,j) = A(i,j) for max(1,j-kd)<=i<=j;
		     if UPLO = 'L', AB(1+i-j,j)    = A(i,j) for j<=i<=min(n,j+kd).

		     On exit, if INFO = 0, the factor S from the split Cholesky
		     factorization A = S**T*S. See Further Details.

	   LDAB

		     LDAB is INTEGER
		     The leading dimension of the array AB.  LDAB >= KD+1.

	   INFO

		     INFO is INTEGER
		     = 0: successful exit
		     < 0: if INFO = -i, the i-th argument had an illegal value
		     > 0: if INFO = i, the factorization could not be completed,
			  because the updated element a(i,i) was negative; the
			  matrix A is not positive definite.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Further Details:

	     The band storage scheme is illustrated by the following example, when
	     N = 7, KD = 2:

	     S = ( s11	s12  s13		     )
		 (	s22  s23  s24		     )
		 (	     s33  s34		     )
		 (		  s44		     )
		 (	     s53  s54  s55	     )
		 (		  s64  s65  s66      )
		 (		       s75  s76  s77 )

	     If UPLO = 'U', the array AB holds:

	     on entry:				on exit:

	      *    *   a13  a24  a35  a46  a57	 *    *   s13  s24  s53  s64  s75
	      *   a12  a23  a34  a45  a56  a67	 *   s12  s23  s34  s54  s65  s76
	     a11  a22  a33  a44  a55  a66  a77	s11  s22  s33  s44  s55  s66  s77

	     If UPLO = 'L', the array AB holds:

	     on entry:				on exit:

	     a11  a22  a33  a44  a55  a66  a77	s11  s22  s33  s44  s55  s66  s77
	     a21  a32  a43  a54  a65  a76   *	s12  s23  s34  s54  s65  s76   *
	     a31  a42  a53  a64  a64   *    *	s13  s24  s53  s64  s75   *    *

	     Array elements marked * are not used by the routine.

       Definition at line 153 of file spbstf.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       spbstf.f(3)