/[virtual-ldap]/bin/csv2yaml.pl
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /bin/csv2yaml.pl

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 21 by dpavlin, Mon Mar 16 10:02:46 2009 UTC revision 26 by dpavlin, Mon Mar 16 14:58:54 2009 UTC
# Line 11  use Data::Dump qw/dump/; Line 11  use Data::Dump qw/dump/;
11  use File::Slurp;  use File::Slurp;
12  use YAML qw/DumpFile/;  use YAML qw/DumpFile/;
13  use Text::CSV;  use Text::CSV;
14  use Encode qw/decode/;  use Encode qw/from_to/;
15    
16  my $debug = 0;  my $debug = 0;
17    
18  my $path = shift @ARGV || die "usage: $0 file.csv\n";  my $path = shift @ARGV || die "usage: $0 file.csv\n";
19    
20  my $csv = read_file( $path );  my $csv = read_file( $path );
21  $csv = decode('utf-16', $csv);  from_to($csv, 'utf-16', 'utf-8');
22    
23  my @columns;  my @columns;
24    
# Line 47  foreach my $line ( split(/\r?\n/, $csv) Line 47  foreach my $line ( split(/\r?\n/, $csv)
47    
48                  # fix tel fields                  # fix tel fields
49                  $v =~ s{\s+}{#}g if $n =~ m{tel};                  $v =~ s{\s+}{#}g if $n =~ m{tel};
50                  $v =~ s[\x{17d}][F] if $n =~ m{spol};                  $v =~ s[\xC5\xBD][F]i if $n =~ m{spol};
51    
52                  if ( $v =~ m{#} ) { # subfields delimiter in CSV data                  if ( $v =~ m{#} ) { # subfields delimiter in CSV data
53                          my @v = split(/\s*#+\s*/, $v);                          my @v = split(/\s*#+\s*/, $v);
Legend:
Removed from v.21  
changed lines
  Added in v.26
  ViewVC Help
Powered by ViewVC 1.1.26