Linux - Transpose rows into column Post: 303001031

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose Rows

Hi, Am trying to transpose a set of rows into a set of comma separated values. For eg. if the output of ps -ef | tail +2 | awk 'BEGIN{ FS=" " } { print $2 }' is 0 1 3 4 I need to transpose it to - '0','1','3','4' Am currently trying -

2. Shell Programming and Scripting

transpose rows to columns

Any tips on how I can awk the input data to display the desired output per below? Thanking you in advance. input test data: 2 2010-02-16 10:00:00 111111111111 bytes 99999999999 bytes 90% 4 2010-02-16 12:00:00 333333333333 bytes 77777777777 bytes 88% 5 2010-02-16 11:00:00...

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

4. Shell Programming and Scripting

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

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

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

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

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

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

LEARN ABOUT OSF1

learn

learn(1)						      General Commands Manual							  learn(1)

NAME

       learn - Provides computer-aided instruction for the C shell

SYNOPSIS

       learn [-directory] [subject] [lesson]

       The learn command provides computer-aided instruction courses and practice in the use of Tru64 UNIX.

OPTIONS

       Allows you to exercise a script in a nonstandard place.

DESCRIPTION

       To  get	started,  enter learn; if this is the first time that you are invoking the learn command, you are guided through a series of ques-
       tions to determine what type of instruction you want to receive.

       If you have used learn before and left your last session without completing a subject, the program uses information  in	$HOME/.learnrc	to
       start you up in the same place you left off.

       To  bypass questions, enter a subject or lesson.  In order to enter a lesson, you must know the lesson number that you received in a previ-
       ous learn command session. If you do not know the lesson number, enter the lesson number as a subject.  The learn command searches for  the
       first  lesson  containing  the subject you specified. If the lesson is a - (dash), learn prompts for each lesson; this is useful for debug-
       ging.

       You can specify the following subjects:

       files editor vi morefiles macros eqn C

SUBCOMMANDS

       There are a few special commands.  The bye command terminates a learn session, and the where command tells you of your  progress  (where  m
       tells  you more.)  The again command redisplays the text of the lesson and again lesson lets you review lesson. The hint command prints the
       last part of the lesson script used to evaluate a response, while hint m prints the entire lesson script.  This	is  useful  for  debugging
       lessons and might possibly give you an idea about what is expected.

EXAMPLES

       To take the online lesson about files, enter: learn files

       You are then prompted for further input.

FILES

       Playpen directories.  Start-up information.

SEE ALSO

       Commands:  csh(1), ex(1)

																	  learn(1)