warn "# fields = ",dump( @fields ) if $debug;
- $hash->{ $columns[$_] } = $fields[$_] foreach ( 0 .. $#fields );
+ foreach ( 0 .. $#fields ) {
+ my $n = $columns[$_];
+ my $v = $fields[$_];
+
+ $v =~ s{\s*#\s*$}{};
+ $v =~ s{^\s+}{};
+ $v =~ s{\s+$}{};
+
+ # fix tel fields
+ $v =~ s{\s+}{#}g if $n =~ m{tel};
+
+ if ( $v =~ m{#} ) {
+ my @v = split(/\s*#\s*/, $v);
+ foreach my $pos ( 0 .. $#v ) {
+ if ( $n =~ m{tel} ) {
+ if ( $v[$pos] =~ m{^09} ) {
+ $hash->{ $n . '_mobile' } ||= $v[$pos];
+ } else {
+ $hash->{ $n . '_fixed' } ||= $v[$pos];
+ }
+ }
+ $hash->{ $n . '_' . $pos } = $v[$pos];
+ }
+ }
+ $hash->{ $n } = $v;
+ }
warn dump( $hash ) if $debug;