Translate
Hi everyone! I have issues translating comma-separated .csv software files (Trados 2019)?
The format of the source text I receive is: ID,"English text",""
My first issue is that in Europe, the separator is a semi-colon, not a comma. My second issue is that when I save the target, Trados doesn't add quotes around the text.
The quickest process I found out is:
1-Don't prepare a project. Drag the file to translate as single file (in file type CVS, I have separator=comma, source=column 2, target=column 3)
2-translate, then save target text with "Save as".
The format of the target file is now: ID;English text;French text
3-open the target .csv in Notepad++. Search for ";"and replace by ","
The format of the target file: ID,English text,French text
4-Add manually all missing quotes around the text
The format of the target file is now the correct one: ID,"English text","French text"
As you can see, adding the missing quotes takes HOURS. It possible that I could miss a quote, which would break the code. The search and replace for ";" to "," is also an issue in case there are semi-colons in the text itself.
Any ideas?
I tried: changing the regional settings to English (US) before prepping the file, adding "sep=," with a text editor at the beginning of the file, using data/convert. All this works to make a nice .csv in Excel, with the text on 3 columns, but that doesn't change the fact that Trados saves the target file in the format "ID;English;French" (semi-colon as separator, no quotes).
