in reply to Regular Expression help, MS Access Pipe delimited export gone bad

My answer assumes that the first fields will never be empty (that is, a pipe being the first character in a line is a sign that there's been a break in the record. 
do {  
    local $/=undef;
    $_=<DATA>;
    ~s~\n\|~\|~g;
    print;
}

[download]
  • Comment on Re: Regular Expression help, MS Access Pipe delimited export gone bad
  • Download Code

In Section Seekers of Perl Wisdom