tagged text in Excel

Jeff Nunner

• February 10, 2016 15:12

The source document is an monolingual Excel document which contains code-like tags in <angle brackets>. We need to mark any word or words in angle brackets as not translatable, whereas the rest of the text should be translatable. The current configuration suppresses the entire cell as not translatable if it contains < or >.

We have tried the following strings in both the segments and words fields, both independently and together:

^([ /\{\<\]]+.*?[ /\{\>\]]+)+$

(?<pattern1>.+)

^\<.*\>$

0

• 

  Stephan Böhmig

  • February 10, 2016 15:30

  Your Excel cells contain markup such as: "<strong>Hello</strong> world." and you want to protect the markup in the translation editor.

  To achieve this you have two options:

  (A)

  In your Excel configuration (monoligual as you say), select the "Do not translate" tab and fill in the regex under "Words or terms":

  \<[a-zA-Z0-9]+?\>

  (Tip: "\<" stands for "<" but you need to escape < and > with a backslash in regular expressions).

   

  See screenshot below:

  

  You can also put a separate regex per tag and give it a name:

  \<strong\>          strong
  \<h1\>                h1
  ....

   

  (B)

  If your "markup" looks like HTML code, another option would be to have the cells be interpreted as HTML code:

  

  This feature should only be used if the cells are pure html and are not formatted with additional Excel styles such as bold, italic, etc.

   

  For general information on configuring Excel mono or multilingual files see:

  http://documents.wordbee.com/display/WBT/Excel+Configuration+Option

   

   

  1
• 

  Jeff Nunner

  • February 10, 2016 15:57

  (B) was not an option for us, since the Excel text did not contain pure HTML.

  (A) worked, as long as you also include a rule for excluding closing tag text:

  \<\/[a-zA-Z0-9]+?\>

  1

Please sign in to leave a comment.