$ echo '------------------------------------------------------------------------------------ > | Vendor | Vendor | Sku Number | Status | Status Detail | > | ID | Name | | | | > ------------------------------------------------------------------------------------ > | | | SNDYN000036000 | Unloadable | The SKU is not valid for the | > | | | | | vendor with vendor number | > | | | | | 875323. |' | perl -pe 's/\|//g; s/\s+/ /g;' ------------------------------------------------------------------------------------ Vendor Vendor Sku Number Status Status Detail ID Name ------------------------------------------------------------------------------------ SNDYN000036000 Unloadable The SKU is not valid for the vendor with vendor number 875323.