[SOLVED] Creating columns from every 4 rows

kbensch · 05-17-2012, 07:14 AM

Hi

I have now tried perl, bash, awk and who knows what else. Tried searching for transpose row to col and col to row and my frustration level is just rising now. Please can someone help me?

Inpit file like this:
\\MSFILEXZ02\BM_LRO
70.00 GB (Hard)
49.93 GB (71%)
20.07 GB
\\MSFILEXZ02\BM_PracticalClassics
70.00 GB (Hard)
58.73 GB (84%)
11.27 GB
\\MSFILEXZ02\TotalTV_Archive
60.00 GB (Hard)
55.14 GB (92%)
4.86 GB
\\MSFILEXZ02\TVChoice_Archive
460.00 GB (Hard)
391.50 GB (85%)
68.50 GB

I basically need 4 columns from it.

Any help or a virtual slap on the forehead to jog the memory would be appreciated.

pan64 · 05-17-2012, 07:42 AM

how should the output look like? (what is that 4 columns)? How did you try it?

colucix · 05-17-2012, 07:46 AM

Maybe something like this?

Code:

awk '{printf "%s\t",$0}; !(NR % 4){printf "\n"}' file

From your sample it produces

Code:

\\MSFILEXZ02\BM_LRO	70.00 GB (Hard)	49.93 GB (71%)	20.07 GB	
\\MSFILEXZ02\BM_PracticalClassics	70.00 GB (Hard)	58.73 GB (84%)	11.27 GB	
\\MSFILEXZ02\TotalTV_Archive	60.00 GB (Hard)	55.14 GB (92%)	4.86 GB	
\\MSFILEXZ02\TVChoice_Archive	460.00 GB (Hard)	391.50 GB (85%)	68.50 GB

with 4 TAB-separated columns (actually 5 being an extra TAB at the end of each line). Is this what you're looking for?

kbensch · 05-17-2012, 07:59 AM

Hi

That is exactly what i was trying to do and from your code I now also know where I messed up. Thank you

Quote:

Originally Posted by colucix

Maybe something like this?

Code:

awk '{printf "%s\t",$0}; !(NR % 4){printf "\n"}' file

From your sample it produces

Code:

\\MSFILEXZ02\BM_LRO	70.00 GB (Hard)	49.93 GB (71%)	20.07 GB	
\\MSFILEXZ02\BM_PracticalClassics	70.00 GB (Hard)	58.73 GB (84%)	11.27 GB	
\\MSFILEXZ02\TotalTV_Archive	60.00 GB (Hard)	55.14 GB (92%)	4.86 GB	
\\MSFILEXZ02\TVChoice_Archive	460.00 GB (Hard)	391.50 GB (85%)	68.50 GB

with 4 TAB-separated columns (actually 5 being an extra TAB at the end of each line). Is this what you're looking for?

pan64 · 05-17-2012, 08:01 AM

ok, that is a possible solution

Code:

awk ' BEGIN { RS="\\\\\\\\" } gsub("\n", "\t") { print ( "\\\\"$0 ) } ' file

rootaccess · 05-19-2012, 11:49 AM

Quote:

Originally Posted by pan64

ok, that is a possible solution

Code:

awk ' BEGIN { RS="\\\\\\\\" } gsub("\n", "\t") { print ( "\\\\"$0 ) } ' file

That is great. I was looking for something like this before, too.
Would there be a way to set the tab somehow ("\t") to get the columns to line up?
Great help, pan64

pan64 · 05-19-2012, 12:30 PM

The problem is the length of the first column. It cannot be lined up with one tab, you need to adjust length.

Code:

awk ' BEGIN { RS="\\\\\\\\"; sp="                              "; OFS="\t" } { $1 = substr($1 sp, 1, 30); print ( "\\\\"$0 ) } ' file

will do the job.

_____________________________________
If someone helps you, or you approve of what's posted, click the "Add to Reputation" button, on the left of the post.

rootaccess · 05-19-2012, 12:35 PM

Beautiful. Now I'm going to devote a large number of hours to see exactly what parameters mean what in that command so I can use it for future reference! Thanks alot!