append two pipes ('|') 2

[mwesticle]

I have a file that conatains roughly 700,000 records. I need a quick way to append two pipe characters to the end of each record. So, If input looks like this:

aaa|bbb|ccc
aaaa|bbbb|cccc
nnnnnnnnnnnnnnnnn

Output needs to look like this:

aaa|bbb|ccc||
aaaa|bbbb|cccc||
nnnnnnnnnnnnnnnnn||

Anyone know how to do this, quickly? I wrote a .ksh script, but it's pretty slow. Maybe use awk or sed? Anyone?

 

[PHV]

The sed way:
sed 's!$!||!' /path/to/input >output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nawlej]

well, it does have 700,000 records, so slow is a relative term, lol

#!/usr/local/bin/perl -w
use strict;

my $filename = "/path/to/filename";
my $outputfile = "/where/to/put/the/output";
open(INFILE "< $filename");
open(OUTFILE "> $outputfile");

while(<INFILE>){

printf(OUTFILE, "%s\|\|\n",$_);
}
close INFILE;
close OUTFILE;