add field for mobite phone

[virtual-ldap] / bin / csv2yaml.pl

diff --git a/bin/csv2yaml.pl b/bin/csv2yaml.pl
index 9a81901..4526926 100755 (executable)
--- a/bin/csv2yaml.pl
+++ b/bin/csv2yaml.pl
@@ -37,7 +37,23 @@ foreach my $line ( split(/\r?\n/, $csv) ) {
 
        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+$}{};
+
+               if ( $v =~ m{#} ) {
+                       my @v = split(/\s*#\s*/, $v);
+                       foreach my $pos ( 0 .. $#v ) {
+                               $hash->{ $n . '_' . $pos } = $v[$pos];
+                               $hash->{ $n . '_mobitel' } = $v[$pos] if $n =~ m{tel} && $v[$pos] =~ m{^09};
+                       }
+               }
+               $hash->{ $n } = $v;
+       }
 
        warn dump( $hash ) if $debug;