$ echo ' | | | SNDYN000036000 | Unloadable | The SKU is not valid for the | | | | | | vendor with vendor number | | | | | | 875323. | ' |  perl -pe 's/\|//g;'
    SNDYN000036000  Unloadable  The SKU is not valid for the       vendor with vendor number       875323.

##</code><code>##

$ echo ' | | | SNDYN000036000 | Unloadable | The SKU is not valid for the | | | | | | vendor with vendor number | | | | | | 875323. | ' |  perl -pe 's/\|//g; s/\s+/ /g;'
 SNDYN000036000 Unloadable The SKU is not valid for the vendor with vendor number 875323.

##</code><code>##

$ 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.

##</code><code>##

$ 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.