• State Verified Answer
  • Replies 9 replies
  • Answers 3 answers
  • Subscribers 433 subscribers
  • Views 4855 views
  • Users 0 members are here
Options
Related

Katakana text appended to content of cell when importing Japanese from bilingual Excel file

Dan Lucas

I am trying to import a bilingual Excel file (xlsx) into SDL Studio 2015 SR2 Freelance, with Japanese in column 1 and English in column 2 of the Excel worksheet, like so:

I open the file in Studio as bilingual Excel, add a new TM during the process and it seems to import both source and target text. The problem is that appended to the Japanese in the source column is a string of katakana text, which is equivalent to the reading of the Japanese for that cell in Excel.

So what should be 定時株主総会 in the source column (Ordinary General Meeting of Shareholders) becomes 定時株主総会テイジカブヌシソウカイ, like so:

From where is it finding / extracting this katakana text and how can I stop it doing this in future?

Thanks

Dan
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply
  • 0 in reply to Dan Lucas
    Of course!

    For storing each unique text from a cell, Excel uses something called a "shared string table" and the content of each cell is the index of the text from that table. When we implemented the filter we erroneously thought that every "shared string" item contains only the text of the cell and some formatting belonging to that text. However, after this post, we found out that the phonetic translations are also found there. This was the problem, since we wrote in Studio all text we found in the shared string item. However, the drawback is that the phonetic translation will be lost when writing back the file, which we hope it won't be a big issue.

    Raul
Children