#! perl use strict; use warnings; ; # Discard header while () { chomp; my @tokens = split /\s+/; my @fields; for (my $i = 0; $i < @tokens; ++$i) { if ($i == 2) { my $from = $tokens[$i]; until ($tokens[++$i] =~ m! ^ \d{1,2} / \d{1,2} $ !x) { $from .= ' ' . $tokens[$i]; } push @fields, $from; } push @fields, $tokens[$i]; } print join('|', @fields), "\n"; } __DATA__ REQID DEST FROM DATE TIME nPages RCV 138454 mail_room Marco's Pizza 12/26 21:52 1 rcv 138446 custsvc 973 618 0577 12/26 18:44 1 rcv 138445 county2 spam 12/26 18:41 3 rcv 138444 custsvc spam 12/26 18:30 1 rcv 138439 county2 7182737253 12/26 17:54 2 rcv 138438 county2 Acme Products, Inc. 12/26 17:52 1 rcv