XML codes in Excel file
Thread poster: JoeFixit

JoeFixit  Identity Verified
Local time: 16:50
English to Norwegian
Sep 26, 2011

Hi!

I have a large Excel file that containts a lot of XML/HTML encoding (which is not to be touched). Is it any way to get SDL Trados 2009 (or 2007 for that matter) to lock the coding and that only the text will be open for translation? As it is now, it's impossible to get an accurate word count and it will be very cumbersome for the translator.

Thanks


Direct link Reply with quote
 

Daniel Weston  Identity Verified
United States
Local time: 07:50
French to English
+ ...
ini file Sep 27, 2011

I'm not sure, but I think it has something to do with the .ini file, which is like a definition file for the xml encoding. I had to translate a huge xml encoded file once and there was a way to load the .ini defninition file into Trados Studio. Once I did that i only saw the text and didn't have to worry about the encoding. When I was done, I saved the file using file, save target as, and the encoding came back. Search for .ini in this forum and you should find what you need. The only problem you might have is if you don't have the original .ini file. Perhaps the client has it? I hope this helps.

Direct link Reply with quote
 

JoeFixit  Identity Verified
Local time: 16:50
English to Norwegian
TOPIC STARTER
No, this is an XLSX file, not XML Sep 27, 2011

No, this is an XLSX file, so there isn't any need for an .ini-file (nor can I choose one, I think).

I think it's an export from a database or something, cause there is a lot of HTML codes in the individual cells. And this is the problem, because I cannot get a proper word count. I need to make Trados understand that the HTML codes should be treated like tags, not text. But that is not easy with an XLSX file.


Direct link Reply with quote
 

Grzegorz Gryc  Identity Verified
Local time: 16:50
French to Polish
+ ...
memoQ Sep 27, 2011

JoeFixit wrote:

No, this is an XLSX file, so there isn't any need for an .ini-file (nor can I choose one, I think).

I think it's an export from a database or something, cause there is a lot of HTML codes in the individual cells. And this is the problem, because I cannot get a proper word count. I need to make Trados understand that the HTML codes should be treated like tags, not text. But that is not easy with an XLSX file.


Use memoQ instead.
It permits to cascade filters i.e . after the XSLX text extraction, the results may be processed with the HTML filter.

Cheers
GG


Direct link Reply with quote
 

JoeFixit  Identity Verified
Local time: 16:50
English to Norwegian
TOPIC STARTER
Thanks Sep 27, 2011

Thanks, I'll definitely check that out

Direct link Reply with quote
 

Roy OConnor
Local time: 16:50
Member (2009)
German to English
Export from Excel Sep 27, 2011

You could try exporting the XL file as a delimited text file. Then change the file extension to XML so that the file type is correctly recognised. Translate this in Trados and then, if hopefully your delimiting characters (say TAB or semicolon) are still intact, import it into Excel again.

You may have to fiddle with the delimiters to stop them interfering with the process.

Roy


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

XML codes in Excel file

Advanced search







SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search