Shell Programming and Scripting

Hi,

I am trying to fetch some values from db and spooling the output to a file.

when i query the db for the values, i get the values in following format.

Code:

PC_1 wf_test1 Test
PC_2 wf_test2 Test
PC_3 wf_test3 Test

But my spool file was created in following format.

Code:

PC_1
wf_test1
Test

PC_2 
wf_test2
Test

PC_3
wf_test3
Test

Now i want to convert the format back to my db format in my spool file. Please let me know how to do it?

-Sam

Not really rows to columns = twirling a matrix on the diagonal, so sed can pile them back up:

Code:

sed '
:loop
$b
N
s/\n$//
t
s/\n/ /
t loop

Narrative: sed:

Code:

#!/usr/bin/perl
open(my $file, q[<], "file.txt") or die("$!");
while(my $line = <$file>)
{
	$line =~ s/\s+/\n/g;
	print $line, "\n";
}
close($file);

Try...

Code:

paste - - - - < file1

Thanks for the explanation. suppose my spool filename is spool.out, where do I need to define this filename in the above code?

Code:

awk '$1=$1' RS= file

It's a transform, just add on the end: < input_file > output_file

The paste bit is cute, too. I try to use sed rather than know the varying options of many one-purpose commands, so my sed knowledge and expertise grows. The sed skills support command line and vi editing as well as grep and the other regex tools. Similar arguments apply to PERL, which is more a language than a scripting tool.