Tag specific text or strings as placeholder using regex in .xlsx
Thread poster: Anja Weiligmann

Anja Weiligmann
Local time: 09:46
Member (2004)
English to German
Aug 28, 2013

Dear all,

when translating xlsx files I often have the following scenario:

Keith talks to Cara

text to be translated

As column A often includes vital information for the context, I'd like it to be shown in SDL Studio Editor, though obviously not as translatable text.
My idea is to add characters like {{{ and }}} at the beginning and end of each cell in column A (I chose {{{ so that no translatable text in column B gets tagged as placeholder) and then to tag these strings as placeholder using regular expressions - I only can't find the correct regular expression. Any ideas?
Thanks in advance,


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

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

Tag specific text or strings as placeholder using regex in .xlsx

Advanced search

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »

  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search