--- bin/csv2yaml.pl 2009/03/15 20:54:14 14 +++ bin/csv2yaml.pl 2009/03/16 14:58:54 26 @@ -11,14 +11,14 @@ use File::Slurp; use YAML qw/DumpFile/; use Text::CSV; -use Encode qw/decode/; +use Encode qw/from_to/; my $debug = 0; my $path = shift @ARGV || die "usage: $0 file.csv\n"; my $csv = read_file( $path ); -$csv = decode('utf-16', $csv); +from_to($csv, 'utf-16', 'utf-8'); my @columns; @@ -47,9 +47,10 @@ # fix tel fields $v =~ s{\s+}{#}g if $n =~ m{tel}; + $v =~ s[\xC5\xBD][F]i if $n =~ m{spol}; - if ( $v =~ m{#} ) { - my @v = split(/\s*#\s*/, $v); + if ( $v =~ m{#} ) { # subfields delimiter in CSV data + my @v = split(/\s*#+\s*/, $v); foreach my $pos ( 0 .. $#v ) { if ( $n =~ m{tel} ) { if ( $v[$pos] =~ m{^09} ) { @@ -60,8 +61,11 @@ } $hash->{ $n . '_' . $pos } = $v[$pos]; } + + $hash->{ $n } = [ @v ]; + } else { + $hash->{ $n } = $v; } - $hash->{ $n } = $v; } warn dump( $hash ) if $debug;