topic Re: rows to column in Operating System - HP-UX

rows to column

DeafFrog — Fri, 21 Mar 2014 21:41:27 GMT

hi Gurus ,

I have a file with entries as below:

var1:mango
quantity:w1245
season: alphanso
var1:apple
quantity:c324
season:winter
var1:cherry
quantity:b4326
season:autumn
....
......

I want the file o/p like

var1 quantity season

mango w1245 alphanso
apple c324 winter
cherry b4326 autumn
mango b67588 spring
....
...

Many thanks ,

Re: rows to column

Dennis Handly — Fri, 21 Mar 2014 22:33:12 GMT

Assuming you have no spaces in the file and the three lines are always in that order:

awk -F: '
{
var1 = $2
getline
quantity = $2
getline
season = $2
print var1, quantity, season
}' input-file

Re: rows to column

DeafFrog — Wed, 26 Mar 2014 12:54:23 GMT

Hi Dennis ,

thank you for the reply.

I used awk -F':' and extracted the second filed and then did a #paste -d"," - - - < details.txt , to generate the required csv.

Thanks once again.

Re: rows to column

Dennis Handly — Thu, 27 Mar 2014 03:46:03 GMT

>I used awk -F':' and extracted the second field and then did a paste

You didn't need to use both awk and paste, you can do it all in awk by changing OFS to comma:

awk -F: -v OFS="," ' ....