Shell Programming and Scripting

hi there,

i'm new to shell scripting as i usually just use our solaris server for db administration and to get some basic system information. however i'm stuck with something that requires further scripting knowledge.

I need to extract the Name, Desc and Status from pkginfo-l.

I need them to be sorted like first column for Name, second column for Desc and third column for Status.

and all these without the words "NAME", "DESC" and "STATUS" appearing. can somebody please help me?

I believe awk is needed and I'm a newbie to sed

Try:

Code:

pkginfo -l |
awk -F":  " '
/NAME:/{s=$2} 
/DESC:/{s=s "," $2} 
/STATUS:/{print s "," $2}'

Thanks Franklin, but i'm sorry i wasn't as precise as i should have been.

i need them aligned in such a way that that would fit into an excel table according to the name, desc and status column. the commas are not needed either. could you please me a little further here? thanks.

You can redirect the output to a file with a .csv extension and open it with Excel.

Regards

Thanks Franklin, i did that first however the problem I have is that when I use the comma delimiter in excel to get them into separate columns, it doesn't work for many rows. simply because there are many commas in the DESC itself. therefore it gets broken up into more than three columns. how do i fix this problem? thank you.

this sounds like problem have move from unix table to spreadsheet one !!!

if using MS excel, try exploring into data->Text to Column wizard.
might be that can solve your purpose.

Instead of comma separated, try pipe separated and open the file in excel by going to Data ->Import External Data

Code:

pkginfo -l |
awk -F":  " '
/NAME:/{s=$2} 
/DESC:/{s=s "|" $2} 
/STATUS:/{print s "|" $2}' > Your_file.txt