Forum Discussion
Metadata Translator and Translations Builder not handling commas in Descriptions for import/export
Hello all,
For our metadata translations workflow, we work with an external translation team. We send them the text that we would like translated, and they send us back a translated .csv or .json file.
I have been attempting to use both Metadata Translator and Translations Builder to export Descriptions from Power BI and import them again from a .csv file. However, in both cases, the Descriptions are getting truncated if they have a comma in them.
For example, if I add French as a language in Translations Builder and a Description reads "This is, a test translation", then the CSV output will put "This is" in the fr-FR column, then "a test translation" in Column 5. If I attempt to import the same string, only "This is" gets imported.
Does anyone have any advice on how to get either one or both programs to honor commas in the Description without resorting to downloading, rewriting, and compiling my own version?