projects
/
virtual-ldap
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
init script for bin/ldap-rewrite.pl
[virtual-ldap]
/
bin
/
csv2yaml.pl
diff --git
a/bin/csv2yaml.pl
b/bin/csv2yaml.pl
index
5193e1e
..
b2623f6
100755
(executable)
--- a/
bin/csv2yaml.pl
+++ b/
bin/csv2yaml.pl
@@
-11,14
+11,14
@@
use Data::Dump qw/dump/;
use File::Slurp;
use YAML qw/DumpFile/;
use Text::CSV;
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 );
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;
my @columns;
@@
-47,7
+47,7
@@
foreach my $line ( split(/\r?\n/, $csv) ) {
# fix tel fields
$v =~ s{\s+}{#}g if $n =~ m{tel};
# fix tel fields
$v =~ s{\s+}{#}g if $n =~ m{tel};
- $v =~ s[\x
{17d}][F]
if $n =~ m{spol};
+ $v =~ s[\x
C5\xBD][F]i
if $n =~ m{spol};
if ( $v =~ m{#} ) { # subfields delimiter in CSV data
my @v = split(/\s*#+\s*/, $v);
if ( $v =~ m{#} ) { # subfields delimiter in CSV data
my @v = split(/\s*#+\s*/, $v);