Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Convert rows to column and print output in required format Post 303040771 by vgersh99 on Wednesday 6th of November 2019 01:07:10 PM
Old 11-06-2019
Strange...
Given your sample input in post#1 and using RudiC's code, I get:
Code:
{"NAME":"QLogic 570x/571x Gigabit Ethernet Driver",
"VERSION":"11.11,REV=2009.11.11",
"BASEDIR":"/"}
{"NAME":"QLogic 57xxx 10/20GbE NIC Driver",
"VERSION":"11.11,REV=2009.11.11",
"BASEDIR":"/"}
{"NAME":"HP Smart Array HBA Driver 2.4.4.1",
"VERSION":"11.11,REV=2009.11.11",
"BASEDIR":"/"}
{"NAME":"cas_migrateconf - The migrateconf class action script for CSW packages",
"VERSION":"1.50,REV=2015.01.17",
"BASEDIR":"/"}
{"NAME":"cas_preserveconf - The preserveconf class action script for CSW packages",
"VERSION":"1.50,REV=2015.01.17",
"BASEDIR":"/"}
{"NAME":"common - common files and dirs for CSW packages",
"VERSION":"1.5,REV=2010.12.11",
"BASEDIR":"/"}
{"NAME":"ggettext_data - GNU locale utilities, translation files",
"VERSION":"0.19.8,REV=2016.09.08",
"BASEDIR":"/"}
{"NAME":"iconv_stub - Transitional package. Content moved to CSWlibcharset1 CSWlibiconv2",
"VERSION":"1.14,REV=2011.08.08",
"BASEDIR":"/"}
{"NAME":"jq - A lightweight and flexible command-line JSON processor.",
"VERSION":"1.4,REV=2014.09.07",
"BASEDIR":"/"}
{"NAME":"libbz2_1_0 - Compression library, libbz2.so.1.0",
"VERSION":"1.0.6,REV=2011.08.18",
"BASEDIR":"/"}
{"NAME":"libcharset1 - GNU iconv charset library, libcharset.so.1",
"VERSION":"1.14,REV=2011.08.07",
"BASEDIR":"/"}
{"NAME":"libiconv2 - GNU iconv library, libiconv.so.2",
"VERSION":"1.14,REV=2011.08.07",
"BASEDIR":"/"}
{"NAME":"libidn11 - GNU IDN library, libidn.so.11",
"VERSION":"1.33,REV=2016.09.05",
"BASEDIR":"/"}

Also, please start using code tags before acquiring too many infractions.....
This User Gave Thanks to vgersh99 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert rows into column

if u have a data 2 4 6 8 5 4 4 5 6 then result shud be like 2 4 6 7 5 4 4 5 6 (3 Replies)
Discussion started by: cdfd123
3 Replies

2. Shell Programming and Scripting

shell script required to convert rows to columns

Hi Friends, I have a log file as below siteid = HYD spc = 100 rset = RS_D_M siteid = DEL spc = 200 rset = RS_K_L siteid = DEL2 spc = 210 rset = RS_D_M Now I need a output like column wise as below. siteid SPC rset HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies

3. Shell Programming and Scripting

Convert Column to rows

Hi, I have a file with below contents. Heading1 Heading2 Heading3 Heading4 Value1 Value2 Value3 Value4 The file has only 2 rows and is tab separated The desired output is : Heading1 Value1 Heading2 Value2 Heading3 Value3 Heading4 Value4 CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies

4. Shell Programming and Scripting

Convert rows into column groups

Hi I have the text file like this "A" "AA Info" "AA Text" "AAA" "ABC" "ABC Info" "ABC Tech" "AGH" "SYN" "SYMBony" "SYN BEREN" Like about 2000 lines Output would be in Column with groups like following "A" "AA Info", "AA Text" "AAA" "ABC","ABC Info","ABC Tech" (0 Replies)
Discussion started by: selvanraj
0 Replies

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

6. Shell Programming and Scripting

Not able to convert the second column to required format

I have this file 103,7243534512111,NiaC1-02 105,720412845543550,NiaC2-00 105,720439254543351,NiaC200 105,720445724354315,Nia100 105,72044770454398,Nia100 105,720484154334546,Nia616 i want in this format insert into aildump values(103,'7243534512111','NiaC1-02'); I'm able to... (3 Replies)
Discussion started by: nikhil jain
3 Replies

7. Shell Programming and Scripting

Convert Rows into Column

Hi Experts, I have a requirement to convert rows into columns. For e.g. Input File: Output File should be like Appreciate if you could suggest code snippet(may be awk) for above requirement... Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies

8. Shell Programming and Scripting

Convert single column into multiple rows

Convert Single column to multiple rows file a.txt contains data like below Server=abc Run=1 Tables=10 Sessions=16 Time=380 Jobs=5 Server=abc Run=2 Tables=15 Sessions=16 Time=400 Jobs=5 Server=abc Run=3 Tables=20 Sessions=16 Time=450 (5 Replies)
Discussion started by: sol_nov
5 Replies

9. Shell Programming and Scripting

Convert rows to column and add header

Hi, I need help to convert rows in input file into a table. inputfile 192.98.1 192.98.192.98.17 VVC family Zorro 10 192.98.1 192.98.192.98.17 VVC family Ace 1 192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies

10. Shell Programming and Scripting

Convert rows into column along with header

Hi, I have a requirement to format the data in a new order. Here is my source format : ppp ***Wed Dec 16 10:32:30 GMT 2015 header1 header2 header3 header4 header5 server1 0.00 0.02 0.07 0.98 server2 0.01 0.00 0.08 0.79 server3 0.05 0.82 0.77 0.86 ... (18 Replies)
Discussion started by: john_prince
18 Replies
PDLACP3(l)						   LAPACK routine (version 1.5) 						PDLACP3(l)

NAME
PDLACP3 - i an auxiliary routine that copies from a global parallel array into a local replicated array or vise versa SYNOPSIS
SUBROUTINE PDLACP3( M, I, A, DESCA, B, LDB, II, JJ, REV ) INTEGER I, II, JJ, LDB, M, REV INTEGER DESCA( * ) DOUBLE PRECISION A( * ), B( LDB, * ) PURPOSE
PDLACP3 is an auxiliary routine that copies from a global parallel array into a local replicated array or vise versa. Notice that the entire submatrix that is copied gets placed on one node or more. The receiving node can be specified precisely, or all nodes can receive, or just one row or column of nodes. Notes ===== Each global data object is described by an associated description vector. This vector stores the information required to establish the mapping between an object element and its corresponding process and memory location. Let A be a generic term for any 2D block cyclicly distributed array. Such a global array has an associated description vector DESCA. In the following comments, the character _ should be read as "of the global array". NOTATION STORED IN EXPLANATION --------------- -------------- -------------------------------------- DTYPE_A(global) DESCA( DTYPE_ )The descriptor type. In this case, DTYPE_A = 1. CTXT_A (global) DESCA( CTXT_ ) The BLACS context handle, indicating the BLACS process grid A is distribu- ted over. The context itself is glo- bal, but the handle (the integer value) may vary. M_A (global) DESCA( M_ ) The number of rows in the global array A. N_A (global) DESCA( N_ ) The number of columns in the global array A. MB_A (global) DESCA( MB_ ) The blocking factor used to distribute the rows of the array. NB_A (global) DESCA( NB_ ) The blocking factor used to distribute the columns of the array. RSRC_A (global) DESCA( RSRC_ ) The process row over which the first row of the array A is distributed. CSRC_A (global) DESCA( CSRC_ ) The process column over which the first column of the array A is distributed. LLD_A (local) DESCA( LLD_ ) The leading dimension of the local array. LLD_A >= MAX(1,LOCr(M_A)). Let K be the number of rows or columns of a distributed matrix, and assume that its process grid has dimension p x q. LOCr( K ) denotes the number of elements of K that a process would receive if K were distributed over the p processes of its process col- umn. Similarly, LOCc( K ) denotes the number of elements of K that a process would receive if K were distributed over the q processes of its process row. The values of LOCr() and LOCc() may be determined via a call to the ScaLAPACK tool function, NUMROC: LOCr( M ) = NUMROC( M, MB_A, MYROW, RSRC_A, NPROW ), LOCc( N ) = NUMROC( N, NB_A, MYCOL, CSRC_A, NPCOL ). An upper bound for these quantities may be computed by: LOCr( M ) <= ceil( ceil(M/MB_A)/NPROW )*MB_A LOCc( N ) <= ceil( ceil(N/NB_A)/NPCOL )*NB_A ARGUMENTS
M (global input) INTEGER M is the order of the square submatrix that is copied. M >= 0. Unchanged on exit I (global input) INTEGER A(I,I) is the global location that the copying starts from. Unchanged on exit. A (global input/output) DOUBLE PRECISION array, dimension (DESCA(LLD_),*) On entry, the parallel matrix to be copied into or from. On exit, if REV=1, the copied data. Unchanged on exit if REV=0. DESCA (global and local input) INTEGER array of dimension DLEN_. The array descriptor for the distributed matrix A. B (local input/output) DOUBLE PRECISION array of size (LDB,M) If REV=0, this is the global portion of the array A(I:I+M-1,I:I+M-1). If REV=1, this is the unchanged on exit. LDB (local input) INTEGER The leading dimension of B. II (global input) INTEGER By using REV 0 & 1, data can be sent out and returned again. If REV=0, then II is destination row index for the node(s) receiving the replicated B. If II>=0,JJ>=0, then node (II,JJ) receives the data If II=-1,JJ>=0, then all rows in column JJ receive the data If II>=0,JJ=-1, then all cols in row II receive the data If II=-1,JJ=-1, then all nodes receive the data If REV<>0, then II is the source row index for the node(s) sending the replicated B. JJ (global input) INTEGER Similar description as II above REV (global input) INTEGER Use REV = 0 to send global A into locally replicated B (on node (II,JJ)). Use REV <> 0 to send locally replicated B from node (II,JJ) to its owner (which changes depending on its location in A) into the global A. Implemented by: G. Henry, May 1, 1997 LAPACK version 1.5 12 May 1997 PDLACP3(l)
All times are GMT -4. The time now is 06:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy