Search Results

This did the trick:
BEGIN { FS = OFS = "|" }
{
print $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,
$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,
...

Here's the output:

3000877|555-55-1111|2|7/30/2008|TEST|P.O. BOX 1111|PALM DESERT|CA|92211||555555555||||||||48|||1||1|3|||2|||||||||||||1|3||2|2...

Here's the data I'm starting with (example output of two combined queries, filesize: 284k)

3000877|555-55-1111|2|7/30/2008|TEST|P.O. BOX 1111|PALM...