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 302718549 by asnandhakumar on Friday 19th of October 2012 06:15:41 PM
Old 10-19-2012
Transpose Datefield from rows to column + Print time diff
Hi Experts,

Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:

Input File:
Code:
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350

Required Output:
Code:
08/23/2012 12:36:14,08/23/2012 12:36:09,00:00:05,JOB_5340
08/23/2012 12:36:26,08/23/2012 12:36:22,00:00:04,JOB_5350

Many Thanks
 

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.f

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 08:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy