fix quotes ("" for single quote)
authorDobrica Pavlinusic <dpavlin@rot13.org>
Sat, 16 Oct 2010 15:29:57 +0000 (17:29 +0200)
committerDobrica Pavlinusic <dpavlin@rot13.org>
Sat, 16 Oct 2010 15:29:57 +0000 (17:29 +0200)
lib/MojoFacets/Import/CSV.pm

index fad2dad..b381bc8 100644 (file)
@@ -19,6 +19,7 @@ sub _split_line {
        my @v;
        while ( $line ) {
                my $v;
+               $line =~ s/""/_qq_/gc;
                if ( $line =~ s/^"\s*([^"]+)\s*"\Q$delimiter\E?// ) {
                        $v = $1;
                } elsif ( $line =~ s/^\s*([^\Q$delimiter\E]+)\s*\Q$delimiter\E?// ) {
@@ -30,6 +31,7 @@ sub _split_line {
                }
 
                $v =~ s/^\s*(.+?)\s*$/$1/;
+               $v =~ s/_qq_/"/g;
                push @v, $v;
        }