Yes, without formatting due to the lack of <code> and </code> tags, it is difficult to know what you need exactly.

Perhaps a starting point: 

$ 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       ven
+dor with vendor number       875323.

[download]
Or, you you want to remove also the extra spaces: 
$ 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 ve
+ndor number 875323.

[download]
Update: I had not seen your new post with the formatted data when I wrote my post. Obviously, a bit more is required, though possibly not so much: 
$ echo '--------------------------------------------------------------
+----------------------
> | Vendor | Vendor | Sku Number      | Status      | Status Detail   
+               |
> | ID     | Name   |                 |             |                 
+               |
> --------------------------------------------------------------------
+----------------
> |        |        | SNDYN000036000  | Unloadable  | The SKU is not v
+alid for the   |
> |        |        |                 |             | vendor with vend
+or number      |
> |        |        |                 |             | 875323.         
+               |'  |  perl -pe 's/\|//g; s/\s+/ /g;'
----------------------------------------------------------------------
+--------------  Vendor Vendor Sku Number Status Status Detail  ID Nam
+e -------------------------------------------------------------------
+-----------------  SNDYN000036000 Unloadable The SKU is not valid for
+ the  vendor with vendor number  875323.

[download]
In brief, you have to tell what to do with the column headers, dashes, etc., and we can get pretty close to your needs. For example, something m perhaps closer to your needs: 
$ echo '--------------------------------------------------------------
+----------------------
> | Vendor | Vendor | Sku Number      | Status      | Status Detail   
+               |
> | ID     | Name   |                 |             |                 
+               |
> --------------------------------------------------------------------
+----------------
> |        |        | SNDYN000036000  | Unloadable  | The SKU is not v
+alid for the   |
> |        |        |                 |             | vendor with vend
+or number      |
> |        |        |                 |             | 875323.         
+               |
> ' | perl -ne 'next if /^\s*-/; s/\|//g; s/\s+/ /g; print;'
 Vendor Vendor Sku Number Status Status Detail  ID Name  SNDYN00003600
+0 Unloadable The SKU is not valid for the  vendor with vendor number 
+ 875323.

[download]

In reply to Re: tricky text file by Laurent_R
in thread tricky text file by raidermike

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.