How do I transpose a column of results to a row

m223464 · #1 (**permalink**) 05-01-2008

Hi,

Can anyone advise me what command I could use to display the results of the following command as a row.

Quote:

i.e. Display this

$ lslpp -l|grep tsm
tivoli.tsm.books.en_US.client.pdf
tivoli.tsm.client.api.32bit
tivoli.tsm.client.api.64bit
tivoli.tsm.client.ba.32bit.base
tivoli.tsm.client.ba.32bit.common
tivoli.tsm.client.ba.32bit.image
tivoli.tsm.client.ba.32bit.nas
tivoli.tsm.client.ba.32bit.web

Like this

tivoli.tsm.books.en_US.client.pdf tivoli.tsm.client.api.32bit tivoli.tsm.client.api.64bit etc

Thanks

Gareth

robotronic · #2 (**permalink**) 05-01-2008

Code:

lslpp -l | grep tsm | tr '\n' ' '

Franklin52 · #3 (**permalink**) 05-01-2008

If you prefer a newline character after the line:

Code:

lslpp -l|awk '/tsm/{ORS=" "}{print}END{print "\n"}' file

m223464 · #4 (**permalink**) 05-01-2008

Quote:

Originally Posted by robotronic

Code:

lslpp -l | grep tsm | tr '\n' ' '

Thanks for this code. It's doing exactly what I asked but unfortunately my plan to use the resulting output as input to another command isn't working.
I was trying to use this as input to the command below, however it's only processing the first item in the list.

Code:

sm_inst installp_cmd -u -f `lslpp -l|grep tsm| tr '\n' ' '`

If I was to type the filesets in manually the command would be as shown below but placing `lslpp -l|grep tsm| tr '\n' ' '` within the quotes doesn't work at all.

Code:

sm_inst installp_cmd -u -f'fileset-1 fileset-2'

I did try the other suggestion but just got an error

Code:

lslpp -l|awk '/tsm/{ORS=" "}{print}END{print "\n"}' file
awk: 0602-533 Cannot find or open file file.
 The source line number is 1.

Can anyone suggest a more sensible and succesful way of implementing this?

thanks

Gareth

robotronic · #5 (**permalink**) 05-01-2008

What about putting the filelist into a variable and let work the shell expansion?

Code:

LIST=`lslpp -l | grep tsm | tr '\n' ' '`
sm_inst installp_cmd -u -f "$LIST"

You have to use double quotes instead of single ones. Maybe you can also get rid of the tr command.

Franklin52 · #6 (**permalink**) 05-01-2008

Quote:

Originally Posted by m223464

I did try the other suggestion but just got an error

Code:

lslpp -l|awk '/tsm/{ORS=" "}{print}END{print "\n"}' file
awk: 0602-533 Cannot find or open file file.
 The source line number is 1.

Oops, you don't read from a file, you can remove that:

Code:

 lslpp -l|awk '/tsm/{ORS=" "}{print}END{print "\n"}'

Regards

m223464 · #7 (**permalink**) 05-06-2008

All working now.

Thanks to both you guys for your assitance and apologies to franklin52 for being a bit stupid when trying to run your command.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to transpose data elements in awk	ahjiefreak	Shell Programming and Scripting	2	05-13-2008 04:44 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
Row to column transpose	videsh77	Shell Programming and Scripting	10	06-16-2007 12:54 PM
transpose command	su_in99	UNIX for Dummies Questions & Answers	3	05-16-2007 05:10 AM
Replace 10th column with a new column--- Terriblly hurry	ahmedwaseem2000	Shell Programming and Scripting	2	09-06-2005 01:10 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by