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

Chloé Daniel
Local time: 16:48
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: 22:48
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: 16:48
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

SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »

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