Technical forums » Trados support »
[Studio 2011] Excel (XLSX) with embedded HTML: How to segment a cell with tags by sentence?
Thread poster: Artem Vakhitov
Artem Vakhitov
Artem Vakhitov  Identity Verified
Kyrgyzstan
English to Russian
+ ...
Dec 11, 2017

After some fiddling with regexes, I've managed to import an XLSX file with embedded HTML content in Studio 2011, but I can't get it to segment by sentence: there are still many segments that contain several sentences, even though I set the "Exclude" hint for "p" and "br" tags. How do I do that without extensive manual splitting? (The file is very l... See more
After some fiddling with regexes, I've managed to import an XLSX file with embedded HTML content in Studio 2011, but I can't get it to segment by sentence: there are still many segments that contain several sentences, even though I set the "Exclude" hint for "p" and "br" tags. How do I do that without extensive manual splitting? (The file is very large.)

Example picture: https://www.dropbox.com/s/3l3sbjt5fsflf9o/xlsx.png?dl=0 ▲ Collapse
 


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

Moderator(s) of this forum
Natalie[Call to this topic]
Myron Netchypor[Call to this topic]
Marco Ramón[Call to this topic]
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

[Studio 2011] Excel (XLSX) with embedded HTML: How to segment a cell with tags by sentence?







Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

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 Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »