Re^3: Parsing MS SQL CSV export with Text::CSV


There's more than one way to do things
	PerlMonks

Re^3: Parsing MS SQL CSV export with Text::CSV_XS

by procura (Beadle)

on Oct 27, 2008 at 11:03 UTC ( [id://719722]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Parsing MS SQL CSV export with Text::CSV_XS
in thread Parsing MS SQL CSV export with Text::CSV_XS

You have an encoding problem

open my $fh, "<:encoding(utf16)", "file.csv";

See for prove:

$ od -t x1 xx.csv
0000000 ff fe 44 00 41 00 52 00 4b 00 0a 00
$ perl -we'open $a, "<:encoding(utf16)", "xx.csv" and print <$a>' | od
+ -t x1
0000000 44 41 52 4b 0a
$
[download]

Comment on Re^3: Parsing MS SQL CSV export with Text::CSV_XS Select or Download Code

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://719722]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others romping around the Monastery: (7)

As of 2024-04-23 08:48 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found