Jump to content

Recommended Posts

Posted

Hi there,

 

I'm having trouble with special characters when trying to load in xml commandreporter reports into Excel. I've traced the problem down to the fact that SIMS creates the xml report as UTF-8, but Excel wants ASCII, and if you use ASCII encoding when loading in the XML file, some characters don't come out right, so for instance, Siôn ends up being SiA'n. Now the obvious solution is just to load in the XML file as UTF-8, but the methods that do this are proving extremely slow, especially as I'm using quite large files with some 400,000 lines of text. I'm trying to investigate various options to get around this, but is it possible to get commandreporter to produce an ASCII encoded file, instead of UTF-8? Can I define that in the param file for instance?

 

Many thanks,

 

Chris

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...