Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

How can I parse CSV data, assuming that the string is encoded in Shift-JIS?

( #37234=categorized question: print w/ replies, xml ) Need Help??
Contributed by Anonymous Monk on Oct 18, 2000 at 00:43 UTC
Q&A  > strings


Description:

I have tried the parse_csv routine from the Perl Cookbook, and it works fine on ascii encoded strings, but as soon as I start using shift-jis, which is a multi-byte character encoding, I end up with wierd results, because sometimes it matches in the middle of a character.

Right now I am using a real parser working character by character, but it is really slow... The problem comes from this line, I think:

my $sjis = q{ [\x00-\x7F] |[\x81-\x9F\xE0-\xFC][\x40-\x7E\x80-\xFC] |[\xA0-\xDF] }; @chars = $text =~ /$sjis/gox;
Any ideas on how to speed this/avoid backtracking?

Thanks

Answer: How can I parse CSV data, assuming that the string is encoded in Shift-JIS?
contributed by AgentM

This may involve more programming than you're interested in, but you can use Jcode at CPAN to come up with your own multibyte char techniques. It's very nice. It might improve your parser to a point where the regexes look more logical.

Please (register and) log in if you wish to add an answer



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others perusing the Monastery: (8)
    As of 2014-09-19 01:30 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      How do you remember the number of days in each month?











      Results (129 votes), past polls