10-21-2016
Hi Don Cragun,
I tried with all suggestions and I thank everyone including you, and as usual (which has happened in the past too!), your solution worked out ideal for me. Given that there are millions of files, one of two might be outliers like the one in example 1. I am running your suggested solution in #4 on my computer and so far I am getting the best results from it. I wanted that the empty column should be deleted and this is what is happening with the output that I am getting. Thanks again for your help. I have coupled your Shell code with a Python code that does more to those tables and both codes are running perfectly now.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi again :$
i am creating a script to be able to monitor a machine's performance.
the code in the file is:
================q==============
sar 2 3 |awk '{print $3}'
vmstat 2 3 |awk '{print $19 " " $21}'
iostat -cx 2 3 |awk '{print $8 " " $10 " " $13}'
================uq=============
the... (4 Replies)
Discussion started by: mohamedh_14
4 Replies
2. Shell Programming and Scripting
Hi there,
I get a list of data set by means a script with many echo command that looks like this:
CASE 1
A= 4
B= 4
CASE 2
A= 3
B= 5
Is... (3 Replies)
Discussion started by: Giordano Bruno
3 Replies
3. UNIX for Advanced & Expert Users
Hi All,
in bash I have a text file which is something like
7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071
2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747
....
....
0.00000E+00 0.0000 0.00000E+00 0.0000 ... (6 Replies)
Discussion started by: f_o_555
6 Replies
4. UNIX for Dummies Questions & Answers
Hi.
I have 2 create 2 temporary tables.the data will be same with same cols..but after creating 2 tables..i have to merge data in file and send..however the query is after merging data no duplicates shud be present..and only 1 record for a entity must be present..
for eg:
table1 has foll cols... (3 Replies)
Discussion started by: musu
3 Replies
5. Shell Programming and Scripting
Hi all ,
am using unix aix ..
Actually i have a table called table 1
in that table
year period startdate enddate
2013 1 26/03/2012 29/04/2012
2013 2 30/04/2012 27/05/2012
2013 3 28/05/2012 28/06/2012
2013 4 25/06/2012 ... (10 Replies)
Discussion started by: Venkatesh1
10 Replies
6. Shell Programming and Scripting
Hi can anyone help me in writing a code for taking data from a table and need to send that data through mail using mail -x command.. (3 Replies)
Discussion started by: ginrkf
3 Replies
7. Shell Programming and Scripting
Hello All,
I have following data into my file named record.
Name City phone number email
Jhon Newyork 123456987 jhon@gmail.com
Maria Texas 569865612 Maria_Sweet@rediffmail.com
Chan Durben NA Chan123@gmail.com
|---------------------------------------------------------------|
|Name ... (2 Replies)
Discussion started by: Nakul_sh
2 Replies
8. Shell Programming and Scripting
Hello All,
I have following data into my file named record.
Name City phone number email
Jhon Newyork 123456987 jhon@gmail.com
Maria Texas 569865612 Maria_Sweet@rediffmail.com
Chan Durben NA Chan123@gmail.com
The output should be in straight columns.. There should not be any... (1 Reply)
Discussion started by: Nakul_sh
1 Replies
9. Shell Programming and Scripting
Hi,
I have a csv file from which i am fetching few columns as below:
IFILE=/home/home1/Report1.csv
OFILE=/home/home1/`date +"%m%d%y%H%M%S"`.dat
if #Checks if file exists and readable
then
awk -F "," '(NR>4) {print $1,$6,$2,$3,$4,$5,$6}' ${IFILE} >> ${OFILE}
fi
cat $OFILE | mail... (7 Replies)
Discussion started by: Vivekit82
7 Replies
10. Shell Programming and Scripting
Hello to all,
I'd like to tabulate the content of the XML file below, I've been trying with AWK putting the Top node (<KIND>) as RS and so far I'm able to print the first and second field of each record, but I don't know how to continue with the following nodes that have more inner nodes.
The... (4 Replies)
Discussion started by: Ophiuchus
4 Replies
LEARN ABOUT REDHAT
zpprfs
ZPPRFS(l) ) ZPPRFS(l)
NAME
ZPPRFS - improve the computed solution to a system of linear equations when the coefficient matrix is Hermitian positive definite and
packed, and provides error bounds and backward error estimates for the solution
SYNOPSIS
SUBROUTINE ZPPRFS( UPLO, N, NRHS, AP, AFP, B, LDB, X, LDX, FERR, BERR, WORK, RWORK, INFO )
CHARACTER UPLO
INTEGER INFO, LDB, LDX, N, NRHS
DOUBLE PRECISION BERR( * ), FERR( * ), RWORK( * )
COMPLEX*16 AFP( * ), AP( * ), B( LDB, * ), WORK( * ), X( LDX, * )
PURPOSE
ZPPRFS improves the computed solution to a system of linear equations when the coefficient matrix is Hermitian positive definite and
packed, and provides error bounds and backward error estimates for the solution.
ARGUMENTS
UPLO (input) CHARACTER*1
= 'U': Upper triangle of A is stored;
= 'L': Lower triangle of A is stored.
N (input) INTEGER
The order of the matrix A. N >= 0.
NRHS (input) INTEGER
The number of right hand sides, i.e., the number of columns of the matrices B and X. NRHS >= 0.
AP (input) COMPLEX*16 array, dimension (N*(N+1)/2)
The upper or lower triangle of the Hermitian matrix A, packed columnwise in a linear array. The j-th column of A is stored in the
array AP as follows: if UPLO = 'U', AP(i + (j-1)*j/2) = A(i,j) for 1<=i<=j; if UPLO = 'L', AP(i + (j-1)*(2n-j)/2) = A(i,j) for
j<=i<=n.
AFP (input) COMPLEX*16 array, dimension (N*(N+1)/2)
The triangular factor U or L from the Cholesky factorization A = U**H*U or A = L*L**H, as computed by DPPTRF/ZPPTRF, packed column-
wise in a linear array in the same format as A (see AP).
B (input) COMPLEX*16 array, dimension (LDB,NRHS)
The right hand side matrix B.
LDB (input) INTEGER
The leading dimension of the array B. LDB >= max(1,N).
X (input/output) COMPLEX*16 array, dimension (LDX,NRHS)
On entry, the solution matrix X, as computed by ZPPTRS. On exit, the improved solution matrix X.
LDX (input) INTEGER
The leading dimension of the array X. LDX >= max(1,N).
FERR (output) DOUBLE PRECISION array, dimension (NRHS)
The estimated forward error bound for each solution vector X(j) (the j-th column of the solution matrix X). If XTRUE is the true
solution corresponding to X(j), FERR(j) is an estimated upper bound for the magnitude of the largest element in (X(j) - XTRUE)
divided by the magnitude of the largest element in X(j). The estimate is as reliable as the estimate for RCOND, and is almost
always a slight overestimate of the true error.
BERR (output) DOUBLE PRECISION array, dimension (NRHS)
The componentwise relative backward error of each solution vector X(j) (i.e., the smallest relative change in any element of A or B
that makes X(j) an exact solution).
WORK (workspace) COMPLEX*16 array, dimension (2*N)
RWORK (workspace) DOUBLE PRECISION array, dimension (N)
INFO (output) INTEGER
= 0: successful exit
< 0: if INFO = -i, the i-th argument had an illegal value
PARAMETERS
ITMAX is the maximum number of steps of iterative refinement.
LAPACK version 3.0 15 June 2000 ZPPRFS(l)