From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sun, 15 Mar 2009 20:01:21 +0000 (+0000)
Subject: if files have magic delimiter # then we will split each
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=73a02aada2b34206f7780a4dcdfaed9dd566cda0;ds=sidebyside

if files have magic delimiter # then we will split each
occurance into it's own field
---

diff --git a/bin/csv2yaml.pl b/bin/csv2yaml.pl
index 9a81901..9d0f9ad 100755
--- a/bin/csv2yaml.pl
+++ b/bin/csv2yaml.pl
@@ -37,7 +37,20 @@ 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*$}{};
+
+		if ( $v =~ m{#} ) {
+			my @v = split(/\s*#\s*/, $v);
+			foreach my $pos ( 0 .. $#v ) {
+				$hash->{ $n . '_' . $pos } = $v[$pos];
+			}
+		}
+		$hash->{ $n } = $v;
+	}
 
 	warn dump( $hash ) if $debug;