$ 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 -ne 'next if /^\s*-/; s/\|//g; s/\s+/ /g; print;' Vendor Vendor Sku Number Status Status Detail ID Name SNDYN000036000 Unloadable The SKU is not valid for the vendor with vendor number 875323.