Hello
I need to translate a .csv file from German into Italian.
The relevant colums are B (Source text) and C (Target text). I have no idea, how to prepare the translation project in Trados in order to translate it.
Can someone help me out? Thank you.
Here a screenshot of the original document:
First thing is to be wary of this:
Excel is notorious for not properly supporting unicode when opening csv files into Excel. If you open the same file in a text editor you'll probably see it doesn't look like that at all. So be careful with the file. You can get around it if you add a BOM to the csv.
The next thing would be to look at the instructions that come with the file. You have five columns separate by a comma:
Knowing this you have two simple ways to handle this.
Bilingual Excel
If you add a BOM to the file you could then import it into Excel rather than simply opening it. This can put each column into a separate column in Excel if you specify the separator to be a comma:
Then just save the file as an XLSX instead of csv. Hide the first six rows as they won't be needed. Then configure the Bilingual Excel settings like this:
CSV
Or just handle the CSV directly using these settings:
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
First thing is to be wary of this:
Excel is notorious for not properly supporting unicode when opening csv files into Excel. If you open the same file in a text editor you'll probably see it doesn't look like that at all. So be careful with the file. You can get around it if you add a BOM to the csv.
The next thing would be to look at the instructions that come with the file. You have five columns separate by a comma:
Knowing this you have two simple ways to handle this.
Bilingual Excel
If you add a BOM to the file you could then import it into Excel rather than simply opening it. This can put each column into a separate column in Excel if you specify the separator to be a comma:
Then just save the file as an XLSX instead of csv. Hide the first six rows as they won't be needed. Then configure the Bilingual Excel settings like this:
CSV
Or just handle the CSV directly using these settings:
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Hello! I don't know if I can ask for help from here, but I received 2 csv files to translate, first time in my life, and don't know how to handle them.
What is a BOM? These instructions are totally non-understandable for me... :-((( Can someone help me?
I'd recommend you create a new thread and provide some examples of what your CSV files look like. We probably only need the first few lines so you can easily change the text and just keep the structure.
What is a BOM?
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Dear Paul,
I'm facing a problem.
I need to translate column 3 in column 4. I adapted the setting but got the message in the printscreen.
How am I suppose to poceed to be able to generate a csv target file?
I'd recommend you create a new thread and provide some examples of what your CSV files look like. We probably only need the first few lines so you can easily change the text and just keep the structure.
This thread already has a verified answer for the original post. If you need to just create a link to refer to this thread... although I don't think you need to as your post isn't related at all.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Translate
