in reply to tricky text file

First, please update your OP to include <code>...</code> tags around the data - the formatting is entirely lost. I am also unsure of what you have tried so far.

It sounds like you want the opposite of format. opposite of format? has some suggestions. Personally, I would:

taking care to handle new data sets properly (emit previous data, store in an array or hash, ...)

--MidLifeXis

Replies are listed 'Best First'.
Re^2: tricky text file
by raidermike (Initiate) on Sep 10, 2015 at 13:32 UTC
    yeah the data is pretty awful, its thousands of "transactions" that look just like this 
    ----------------------------------------------------------------------
+--------------
| Vendor | Vendor | Sku Number      | Status      | Status Detail     
+             |
| ID     | Name   |                 |             |                   
+             |
----------------------------------------------------------------------
+--------------
|        |        | SNDYN000036000  | Unloadable  | The SKU is not val
+id for the   |
|        |        |                 |             | vendor with vendor
+ number      |
|        |        |                 |             | 875323.           
+             |

    [download]
    i just want to put the readable data (the text) in one line each
[reply]
[d/l]

In Section Seekers of Perl Wisdom