Sponsored Content
Top Forums Shell Programming and Scripting Have a situation while extracting info Post 302919258 by deepakiniimt on Tuesday 30th of September 2014 12:04:37 AM
Old 09-30-2014
thanks guys , i am able to handle this situation . actually i used both methods from chubler_XL and vgersh99 .

let me explain in details what exactly i have and why i used both and still may be we can use one method instead of 2.
1. i am extracting some data from 2 tables , that will be in a text file.
2. now i want to sort/extract data from that text file based on my requirement .
3. date may vary , and so status .
4. for each num, Status can be any value , either DONE or REDONE. for same NUM, sequence can be DONE, DONE, REDONE, DONE
but if i use awk 'a!=$2{print;a=$2}' myFile -> it returns DONE, REDONE , DONE only for same NAME column.
5. if ENV column values are different but STATUS column value is same(DONE or REDONE), above logic will not work, it will return one row only. then i used this logic awk '!a[$2,$4,5]++' infile

how to get desired output in one command , right now i am using both logic in IF loop

Code:
NUM      Status      NAME                                ENV                        DATE       Time
100050596 DONE        PAB                              scotau1@csomrc1           23-SEP-14 06:49:33
 100050596 DONE        PAB                             scotau1@csomrc1           23-SEP-14 06:49:36
 100050596 DONE        PAB                              scotau1@csomrc1           23-SEP-14 06:49:38
 100050596 DONE        PAB                              scotau2@csomrc1           23-SEP-14 06:51:51
 100050596 DONE        PAB                              scotau2@csomrc1           23-SEP-14 06:51:53
 100050596 DONE        PAB                              scotau2@csomrc1           23-SEP-14 06:51:56
 100050596 DONE        PAB                              scotau3@csomrc1           23-SEP-14 06:53:05
 100050596 DONE        PAB                              scotau3@csomrc1           23-SEP-14 06:53:08
 100050596 DONE        PAB                              scotau3@csomrc1           23-SEP-14 06:53:10
100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 20:58:42
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 20:58:56
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 20:59:09
 100051482 UNDONE      SMO                              occbap1@hppabc1          24-SEP-14 21:04:25
 100051482 UNDONE      SMO                              occbap1@hppabc1          24-SEP-14 21:04:38
 100051482 UNDONE      SMO                              occbap1@hppabc1          24-SEP-14 21:04:51
 100051482 DONE        SMO                             occbap1@hppabc1          24-SEP-14 21:05:52
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:06:06
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:06:19
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:06:32
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:07:25
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:07:38
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:07:51
 100051482 DONE        SMO                              occbap1@hppabc1          24-SEP-14 21:08:04


Last edited by deepakiniimt; 09-30-2014 at 01:22 AM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

extracting info from Unix database to construct a visual diagram

Ok heres the situation, We use Solaris 8 at work with Sybase for the db. I need to be able to easily create visual diagrams of some of our more complex systems. I've been using Visio which is such a manual process and takes a while. I was thinking maybe using Visio somehow in conjunction... (0 Replies)
Discussion started by: fusion99
0 Replies

2. UNIX for Dummies Questions & Answers

Extracting Info

i have a file that contain lines like this 9.4.7.8.5.7.9.0.5.7.1.2.msisdn.sub.cs. 1 IN CNAME SDP01.cs. there are about 50,000 lines like this in the files i want to the extract the digits from the above line like:- 947857905712 OS Solaris9 (3 Replies)
Discussion started by: muneebr
3 Replies

3. UNIX for Dummies Questions & Answers

Extracting specific info from finger command

Hello all, my unix is bash based and the finger command output is: Login Name Tty Idle LoginTime Office amos.john Amos John pts/26 1 Dec 5 16:18 (77.100.22.07) What am trying to achieve is extract the Login (amos.john) and Name (Amos John) from this output without using awk or sed. ... (1 Reply)
Discussion started by: franny
1 Replies

4. UNIX for Dummies Questions & Answers

Extracting spec info from finger.

Hi everyone, I'm trying to extract the user name and full name from the finger command without using sed or awk. Any pointers? Thanks in advance. (6 Replies)
Discussion started by: franny
6 Replies

5. UNIX for Dummies Questions & Answers

help : crisis situation !!

Hi I had deleted important files from my company server :( the server is HPUX and i don't know how to undo rm command or how to restore the files .. iam appreciate for any help Thanx ... (5 Replies)
Discussion started by: Eisa
5 Replies

6. Programming

problems iterating in RUBY while extracting info from YAML, Pls help!

Hi all, I am stuck with a ruby script that extracts detials from yaml file and processes accordingly. the yaml file confivnic: device: vnic1: policy: - L2 mode: active vnic2: policy: - L3 - L4 mode: active type: aggr ... (1 Reply)
Discussion started by: wrapster
1 Replies

7. UNIX for Dummies Questions & Answers

Extracting 482/300k columns no's with respective info. listed in file2 from file1

Hi, I have 2 files File 1: 1 2 3 4 5 6 .......etc until column 300K 1 23 21 24 12 22 1 23 21 24 12 22 1 23 21 24 12 22 1 23 21 24 12 22 1 23 21 24 12 22 1 23 21 24 12 22 1 23 21 24 12 22 . . etc until row 1411 File 2: (14 Replies)
Discussion started by: sogi
14 Replies

8. Shell Programming and Scripting

matching and extracting info from text files

Hi all, I have two .txt file i.e. First text file: 2 4 1 4 Second text file 2 1.nii.gz 4 334.nii.gz 1 12.nii.gz 4 134.nii.gz If entry in 1st column of 1st text file matches the 1st column of 2nd text file, then copy the file (name of which is the second column) associated with... (4 Replies)
Discussion started by: vd24
4 Replies

9. Solaris

Extracting HBA Card Hardware info

Hello, I am very new to solaris so please bear with me. I have 2 machines in question. For both I am trying to get the HBA Card Hardware information such as: HBA Model Name HBA Firmware version HBA Port details HBA Driver details First machine is a Solaris 10. When I execute fcinfo... (6 Replies)
Discussion started by: flagman5
6 Replies

10. UNIX for Dummies Questions & Answers

Extracting specific info finger command

how to extract user machine name for current terminal using finger command below command gives machinename for all session , is it possible to filter it to only currernt terminal ? finger -b -p $LOGNAME | grep from (12 Replies)
Discussion started by: lalitpct
12 Replies
ddisna.f(3)							      LAPACK							       ddisna.f(3)

NAME
ddisna.f - SYNOPSIS
Functions/Subroutines subroutine ddisna (JOB, M, N, D, SEP, INFO) DDISNA Function/Subroutine Documentation subroutine ddisna (characterJOB, integerM, integerN, double precision, dimension( * )D, double precision, dimension( * )SEP, integerINFO) DDISNA Purpose: DDISNA computes the reciprocal condition numbers for the eigenvectors of a real symmetric or complex Hermitian matrix or for the left or right singular vectors of a general m-by-n matrix. The reciprocal condition number is the 'gap' between the corresponding eigenvalue or singular value and the nearest other one. The bound on the error, measured by angle in radians, in the I-th computed vector is given by DLAMCH( 'E' ) * ( ANORM / SEP( I ) ) where ANORM = 2-norm(A) = max( abs( D(j) ) ). SEP(I) is not allowed to be smaller than DLAMCH( 'E' )*ANORM in order to limit the size of the error bound. DDISNA may also be used to compute error bounds for eigenvectors of the generalized symmetric definite eigenproblem. Parameters: JOB JOB is CHARACTER*1 Specifies for which problem the reciprocal condition numbers should be computed: = 'E': the eigenvectors of a symmetric/Hermitian matrix; = 'L': the left singular vectors of a general matrix; = 'R': the right singular vectors of a general matrix. M M is INTEGER The number of rows of the matrix. M >= 0. N N is INTEGER If JOB = 'L' or 'R', the number of columns of the matrix, in which case N >= 0. Ignored if JOB = 'E'. D D is DOUBLE PRECISION array, dimension (M) if JOB = 'E' dimension (min(M,N)) if JOB = 'L' or 'R' The eigenvalues (if JOB = 'E') or singular values (if JOB = 'L' or 'R') of the matrix, in either increasing or decreasing order. If singular values, they must be non-negative. SEP SEP is DOUBLE PRECISION array, dimension (M) if JOB = 'E' dimension (min(M,N)) if JOB = 'L' or 'R' The reciprocal condition numbers of the vectors. INFO INFO is INTEGER = 0: successful exit. < 0: if INFO = -i, the i-th argument had an illegal value. Author: Univ. of Tennessee Univ. of California Berkeley Univ. of Colorado Denver NAG Ltd. Date: November 2011 Definition at line 118 of file ddisna.f. Author Generated automatically by Doxygen for LAPACK from the source code. Version 3.4.1 Sun May 26 2013 ddisna.f(3)
All times are GMT -4. The time now is 01:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy