--- trunk/parse_format.pm 2004/03/29 19:41:12 293 +++ trunk/parse_format.pm 2004/09/29 17:22:24 488 @@ -56,7 +56,7 @@ my $f = $format; my $eval; - $eval = $1 if ($f =~ s/^eval{([^}]+)}//); + $eval = $1 if ($f =~ s/^eval{([^}]+?)}//); if ($f =~ s/^([^\d]+)//) { if ($f) { # there is more to parse @@ -163,15 +163,17 @@ sub fld2str { my ($func,$row,$f,$sf,$i) = @_; #print STDERR "## in fld2str\n"; - my $tmp = $codepage->convert(&$func($row,$f,$sf,$i)) || ''; + my $tmp = $codepage->convert(&$func($row,$f,$sf,$i)) || $codepage->convert(&$func($row,$f,$sf,0)) || ''; return "'$tmp'"; } $eval =~ s/v(\d+)\^(\w*)/fld2str($func,$row,$1,$2,$i)/eg; #print STDERR "## eval: $eval\n"; if (eval "$eval") { + die "eval error: eval{$eval}: $@" if ($@); return ($swish,$display); } else { + die "eval error: eval{$eval}: $@" if ($@); return (undef,undef); } } @@ -192,7 +194,14 @@ my $format = shift; my $row = shift; my $i = shift; - my $codepage = shift; + #my $codepage = shift; + # + # data allready comes in utf-8 due to change in + # SpreadSheet::ParseExcel::FmtDefault line 69 from + # return pack('C*', unpack('n*', $sTxt)); + # to following which returns utf-8: + # return pack('U*', unpack('n*', $sTxt)); + # return if ($i > 0); # Excel doesn't support repeatable fields @@ -213,9 +222,6 @@ #print STDERR "--$1-> $format -[",length($format),"] "; if ($row->{$1}) { my $tmp = $row->{$1}; - if ($codepage) { - $tmp = $codepage->convert($tmp) || warn "excel: $1 '$tmp' can't convert"; - } $display .= $prefix . $tmp; $swish .= $tmp." "; #print STDERR " == $tmp"; @@ -224,7 +230,7 @@ } elsif ($format =~ s/^([^A-Z\|]+)(\|[A-Z]{1,2}\|)/$2/) { $prefix .= $1 if ($display); } else { - print STDERR "unparsed format: $format\n"; + #print STDERR "unparsed format: $format\n"; $prefix .= $format; $format = ""; }