Cobby generated CSV file with HTML
Thread poster: Chloé Daniel

Chloé Daniel
Local time: 18:16
English to French
+ ...
Jul 26, 2017

[I added spaces in the quoted html text for it to be displayed]
I received a csv file to translate. It was generated from Cobby, an interface between Magento and Excel, and contains html text. Example:

< u l>[cLineBreak]< li >Geh & a u m l ; use aus blabla"< / li >[cLineBreak]< li >fest montierte blabla aus unbeschichtetem bla"< / li >)

I am not used to having such a text in Studio so I used "search and replace all" to prepare the file in excel, replacing all "& a u m l ;"-like code with the corresponding accentuated letters, and I managed to set conditions in Trados for this type of file and I succeeded in generating Studio tags for the regular html tags (< ul >, < li >, etc.). But problems still remain:

* I wasn't able to hide this [cLineBreak] into a Studio tag, it makes the wordcount totally false

* I need to find a way to tell Studio to start a new segment after < ul > tags, < li > tags, etc.

Do any of you know how to set Studio to hide this tag / get a better segmentation? Do any of you know an automatic solution to convert text that contains these "& a u m l ;" accentuated letters into a text with regular accentuated letters wihtout having to use search and replace all? (And back into html at the end as I have to deliver a file with no accentuated letters or special caracters)

Thanks in advance



Shouguang Cao
Local time: 00:16
Member (2007)
English to Chinese
+ ...
Know this frustration Jul 27, 2017

Don't translate such CSV file in Trados. They haven't provided solutions to probably any of your requests yet.

[Edited at 2017-07-27 08:05 GMT]


Chloé Daniel
Local time: 18:16
English to French
+ ...
Still better than without Studio I think Jul 27, 2017

Thank you for your reply. I think I will still use Trados though, because even if my workaround isn't perfekt, it gets the job done and I have so many repetitions that it is still worth it.
But you are right, if I happen to have such a file in the future without reps and the need for a termbase, I will translate it without Studio.


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Cobby generated CSV file with HTML

Advanced search

memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search