Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Transpose Datefield from rows to column + Print time diff
Top Forums Shell Programming and Scripting Transpose Datefield from rows to column + Print time diff Post 302719317 by asnandhakumar on Monday 22nd of October 2012 11:15:41 AM
Old 10-22-2012
Spacebar, Agama

I have tried the suggested changes, and it still errors out...

Changed code:
Code:
while IFS="," read inDate jobName
c=0
do
c=$(($c+1))
if [[$c -eq 1]]; then
ts1=$inDate
else
s=$(($(date -d "$inDate" +%s) - $(date -d "$ts1" +%s)))
printf "$inDate,$ts1,%02d:%02d:%02d" $((s/3600)) $((s%3600/60)) $((s%60))
echo ",$jobName"
fi
done <t.csv

Error Message:
Code:
./trans.ksh[19]: [[1:  not found.
date: Not a recognized flag: d
Usage: date [-u] [+"Field Descriptors"]
date: Not a recognized flag: d
Usage: date [-u] [+"Field Descriptors"]
./trans.ksh[22]:  - : 0403-053 Expression is not complete; more tokens expected.

I'm using ksh on AIX machine, and the ksh version is Version M-11/16/88f

Many thanks for your help
NK
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk transpose rows to column

Need to transpose in awk rows to column like this: input: A1,6,5,4 3,2,1, A2,8,7,9,10,11,12,13,14 A3,1,2,3,5,7,8,9 A4,9,4,8,1,5,3, output: A1,1 A1,2 A1,4 ... A2,7 A2,8 ... A3,1 A3,2 ... A4,1 A4,3 (5 Replies)
Discussion started by: sdf
5 Replies

2. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

3. Shell Programming and Scripting

Transpose timestamp based on column values and calculate time difference

Hello Expert, I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom INPUT File ======== 08/23/2012 12:36:09 JOB_5340 08/23/2012 12:36:14 JOB_5340 08/23/2012... (2 Replies)
Discussion started by: asnandhakumar
2 Replies

4. Shell Programming and Scripting

awk to transpose preceding row to 1st column of next rows

Gurus: How can I transpose the output below to a format in which I can plot a graph to show VSZ memory usage by PIDs? stdout: Tue Jan 22 07:29:19 CUT 2013 42336296 1841272 java wilyadm 21889232 438616 jlaunch sidadm 42532994 414336 jlaunch sidadm Tue Jan 22 07:49:20 CUT 2013... (1 Reply)
Discussion started by: ux4me
1 Replies

5. Shell Programming and Scripting

Transpose Column of Data to Rows

I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows: NAME=BOB ADDRESS=COLORADO PET=CAT NAME=SUSAN ADDRESS=TEXAS PET=BIRD NAME=TOM ADDRESS=UTAH PET=DOG I would... (7 Replies)
Discussion started by: docdave78
7 Replies

6. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Discussion started by: sara.nowreen
3 Replies

7. Shell Programming and Scripting

Peel syntax for transpose rows into column

Dear all, Plz let me know syntax for transposing rows into column in perl, I am having 30 csv files which are merged into a single xls sheet. but i want to transpose each row into column in excel sheet in each tab (1 CSV = 1tab in xls sheet) example is as below ... (0 Replies)
Discussion started by: sagar_1986
0 Replies

8. Programming

To transpose rows to column in hadoop

Hi, i am having an HDFS file which is comma seperated, i need to transpose from rows to column only the header columns text.csv cnt,name,place 1,hi,nz 2,hello,aus I need cnt, name, place while using below command in hadoop getting the error hadoop fs -fmt -1 text.csv (0 Replies)
Discussion started by: rohit_shinez
0 Replies

9. Shell Programming and Scripting

Linux - Transpose rows into column

hello, I have a server that collect some performance statistics of 4 servers in the following input file : $ cat inputfile Time,A,Server1,KPI1,data1 Time,A,Server1,KPI2,data2 Time,A,Server1,KPI3,data3 Time,A,Server1,KPI4,data4 Time,A,Server1,KPI5,data5 Time,A,Server2,KPI1,data6... (9 Replies)
Discussion started by: capitain25
9 Replies

10. UNIX for Beginners Questions & Answers

How to transpose pieces of data in a column to multiple rows?

Hello Everyone, I am very new to the world of regular expressions. I am trying to use grep/sed for the following: Input file is something like this and there are multiple such files: abc 1 2 3 4 5 ***END*** abc 6 7 8 9 ***END*** abc 10 (2 Replies)
Discussion started by: shellnewuser
2 Replies

LEARN ABOUT DEBIAN

cla_gbrcond_x

cla_gbrcond_x.f(3)						      LAPACK							cla_gbrcond_x.f(3)

NAME

       cla_gbrcond_x.f -

SYNOPSIS

   Functions/Subroutines
       REAL function cla_gbrcond_x (TRANS, N, KL, KU, AB, LDAB, AFB, LDAFB, IPIV, X, INFO, WORK, RWORK)
	   CLA_GBRCOND_X

Function/Subroutine Documentation
   REAL function cla_gbrcond_x (characterTRANS, integerN, integerKL, integerKU, complex, dimension( ldab, * )AB, integerLDAB, complex, dimension(
       ldafb, * )AFB, integerLDAFB, integer, dimension( * )IPIV, complex, dimension( * )X, integerINFO, complex, dimension( * )WORK, real,
       dimension( * )RWORK)
       CLA_GBRCOND_X

       Purpose:

	       CLA_GBRCOND_X Computes the infinity norm condition number of
	       op(A) * diag(X) where X is a COMPLEX vector.

       Parameters:
	   TRANS

		     TRANS is CHARACTER*1
		Specifies the form of the system of equations:
		  = 'N':  A * X = B	(No transpose)
		  = 'T':  A**T * X = B	(Transpose)
		  = 'C':  A**H * X = B	(Conjugate Transpose = Transpose)

	   N

		     N is INTEGER
		The number of linear equations, i.e., the order of the
		matrix A.  N >= 0.

	   KL

		     KL is INTEGER
		The number of subdiagonals within the band of A.  KL >= 0.

	   KU

		     KU is INTEGER
		The number of superdiagonals within the band of A.  KU >= 0.

	   AB

		     AB is COMPLEX array, dimension (LDAB,N)
		On entry, the matrix A in band storage, in rows 1 to KL+KU+1.
		The j-th column of A is stored in the j-th column of the
		array AB as follows:
		AB(KU+1+i-j,j) = A(i,j) for max(1,j-KU)<=i<=min(N,j+kl)

	   LDAB

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

	   AFB

		     AFB is COMPLEX array, dimension (LDAFB,N)
		Details of the LU factorization of the band matrix A, as
		computed by CGBTRF.  U is stored as an upper triangular
		band matrix with KL+KU superdiagonals in rows 1 to KL+KU+1,
		and the multipliers used during the factorization are stored
		in rows KL+KU+2 to 2*KL+KU+1.

	   LDAFB

		     LDAFB is INTEGER
		The leading dimension of the array AFB.  LDAFB >= 2*KL+KU+1.

	   IPIV

		     IPIV is INTEGER array, dimension (N)
		The pivot indices from the factorization A = P*L*U
		as computed by CGBTRF; row i of the matrix was interchanged
		with row IPIV(i).

	   X

		     X is COMPLEX array, dimension (N)
		The vector X in the formula op(A) * diag(X).

	   INFO

		     INFO is INTEGER
		  = 0:	Successful exit.
		i > 0:	The ith argument is invalid.

	   WORK

		     WORK is COMPLEX array, dimension (2*N).
		Workspace.

	   RWORK

		     RWORK is REAL array, dimension (N).
		Workspace.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Definition at line 153 of file cla_gbrcond_x.f.

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

Version 3.4.1							  Sun May 26 2013						cla_gbrcond_x.f(3)
All times are GMT -4. The time now is 04:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy