topic Re: Easy Script in Operating System - Linux

Easy Script

Joseph C. Denman — Wed, 26 Oct 2005 16:28:32 GMT

I just can't get it. I have 21 files and each has one field. I want to combine all the files into one with all the fields matching on each line separated by a :

example:

file1.
xxxx11111
xxxx11111
bbbb22222

file2.
c
d
a

file3.
abcd1234
asdfjkl;

The file I want:
xxxx1111:c:abcd1234:
xxxx1111:d:asdfjkl;:
bbbb2222:a::

How can I combine the files?????

Thanks,

jcd...

Re: Easy Script

A. Clay Stephenson — Wed, 26 Oct 2005 16:32:21 GMT

Easy

paste -d : file1 file2 ... filen > outfile

Man paste for details.

Re: Easy Script

James R. Ferguson — Wed, 26 Oct 2005 16:33:50 GMT

Hi Joesph:

# paste -d ":" file1 file2 file3 ...

Regards!

...JRF...

Re: Easy Script

Hein van den Heuvel — Wed, 26 Oct 2005 20:32:57 GMT

Paste is probably the way to go.

To produce EXACTLY the requested result just add /dev/null as a final file to force the final seperator.

$ paste -d : file* /dev/null
xxxx11111:c:abcd1234:
xxxx11111:d:asdfjkl;:
bbbb22222:a::

If you need more elaborate logic in the paste operation (dealing with empty lines?), then you may want to script it, perhaps in perl. For example:

-------- paste.p --------
$sep = shift @ARGV;
while () {
$i=0;
open F,"<$_";
while (){
chop;
@lines[$i++] .= $_ . $sep;
}
@lines[$i++] .= $sep while ($i < $m);
$m = $i;
}
print "$_\n" foreach @lines;

----------- sample usage ----------

$ perl paste.p : file*
xxxx11111:c:abcd1234:
xxxx11111:d:asdfjkl;:
bbbb22222:a::

fwiw,
Hein.

Re: Easy Script

Muthukumar_5 — Thu, 27 Oct 2005 01:28:37 GMT

pr -ms: -t file*

or

pr -ms: -t file1 file2 file3 ... filen

will do it.

-Muthu

Re: Easy Script

Joseph C. Denman — Tue, 01 Nov 2005 12:18:25 GMT

Thanks folks. Ya'll are the best!!! I guess that is why all the head gear!@#$%&*(

Thanks Again,

...jcd...

Re: Easy Script

Joseph C. Denman — Tue, 01 Nov 2005 12:19:18 GMT

Thread Closed. Solutions above.