Bill Roper (billroper) wrote,
Bill Roper
billroper

XML Follies

Things I learned about XML today:

  • It would be easier to work with if I was using someone else's parser, instead of the undocumented home-grown one that I'm stuck with for the moment.
  • UTF-16 is all well and good, but even if Excel reads an XML file in that format, it will damned well write it back out in UTF-8.
  • Exactly why Excel complains about denormalized data remains a mystery, but by deleting the attribute of a tag that was nested two levels out, you can get it to quit complaining and do what you want.
  • Word will also write out the file in UTF-8 format and will thoughtfully remove the CR/LF information. There's nothing like a 59,000 character line.
  • Unicode isn't more trouble than it's worth, but it would be nice if Microsoft's support for it was a bit better.
Tags: musings, work
Subscribe

  • Time for Rebuilding

    Well, there's nothing like research. Having determined that DDR5 is going to carry a substantial price premium over DDR4 memory for at least a year…

  • Driven Wild

    The studio computer continues to misbehave in various ways. When I fired up Cubase today, I got a lot of nasty, blocky video, despite having cleaned…

  • Some Old Doggerel

    I recall having mangled a CSN tune many years ago on the way to Contraption. Like that convention, the particular co-worker whose code I was digging…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 3 comments