Hi both,

As requested, please find on this link the source CSV file and the Greek translation: drive.google.com/open

Paul, from what I understand, I need to first change the encoding on the source file to UTF-8, translate it into Trados, generate the target file, and then open it on Excel? I have done this, and the Greek characters are still not displayed properly.

I'm suspecting that when I process the source file on File Encoding Converter (FEC), the file encoding is not successfully converted to UTF-8. The reason I'm suspecting it is that the modification date on the properties of the source file does not change after the processing of FEC. Could you please confirm the steps in order to convert the encoding of a source CSV file on FEC?

Many thanks.

Chris

Unknown said:

Could you please confirm the steps in order to convert the encoding of a source CSV file on FEC?

I created a short video to explain to you how to do this... hope it helps:

Hi Paul,

A huge thanks for this one! All works well now. As suspected, I hadn't processed the file correctly. I didn't know I had to also change the property of assigning a BOM on File Encoding Converter.

Your video actually solved another problem that I thought was unsolvable. If I understand correctly, with the options you applied at the latter half of the video, one can translate all cells (including all columns) of a CSV file. I thought that CSVs are translated only as bilingual files on Trados, as it gives you the option to choose only one column as the source and one as the target.

Best,

Chris

Unknown said:

Your video actually solved another problem that I thought was unsolvable. If I understand correctly, with the options you applied at the latter half of the video, one can translate all cells (including all columns) of a CSV file. I thought that CSVs are translated only as bilingual files on Trados, as it gives you the option to choose only one column as the source and one as the target.

Indeed... that's why I shared what I did.  I hadn't thought about this before but it does seem a little short sighted not to support the ability to handle CSV files where the entire content needs translating... unless I'm also missing something!

Unknown said:

Your video actually solved another problem that I thought was unsolvable. If I understand correctly, with the options you applied at the latter half of the video, one can translate all cells (including all columns) of a CSV file. I thought that CSVs are translated only as bilingual files on Trados, as it gives you the option to choose only one column as the source and one as the target.

Indeed... that's why I shared what I did.  I hadn't thought about this before but it does seem a little short sighted not to support the ability to handle CSV files where the entire content needs translating... unless I'm also missing something!

Could you please paste here the symbols I need to add in the Rule Opening while on the Inline Tags window of the csv_greek file in Options (03:14 of the video tutorial)? I cannot see them clearly in the video. Thanks.

Sure...

((?<!\d)[,]|[,](?!\d))

"

\s"