in reply to Re: Regex with malformed CSV files
in thread Regex with malformed CSV files

well so far the above solution solved the malformed portion of outlook regarding newlines. to solve the problem of the embedded quotes i'm using...
$line =~ s/(?<!,)"{1,2}(?!,)/""/g;
basically just adds two quotes if it finds one, or two quotes that are not preceeded or followed by a (,) comma. This still won't solve a rule if there's one such as

"my address is ",320 main street" virginia". but in all honesty... how often is it going to happen? :) thanks for the help everyone.