Regular Expressions


 

Starting point

You would like to translate an Excel sheet in Across which contains cells that are exclusively made up of figures, order and article numbers etc. such as 123456 or 12-3456-7890.

 

Sample document:

 

Task outline

As it is certain that numbers need not be adjusted in the target language, the cells described above should not be displayed for translation in crossDesk.

 

Representation with regular expressions

The following string represents the figures and numbers as regular expressions:

^[0-9\-]+$

The character string is built up as follows: it stands for any figures (0-9), that can be separated by a hyphen (\-) and may occur any number of times, but at least once (+). The operators ^ (beginning of a paragraph or cell) and $ (end of paragraph or cell) ensure that only paragraphs or cells that consist exclusively of the respective figures or numbers are found and "hidden".

 

Put into practice in Across

Select an Excel template in the system settings via >>Tools >>System Settings… >>Document Settings >>Excel or create a new one by clicking the button New. Then click Add… to insert the regular expression into the template.

Select "Context“ as filter and enter the string of the regular expression into the input field. Then select the option "hidden" as you do not want the corresponding cells to be visible in crossDesk and click "OK.

Now check in the Excel file and employ the Excel template when creating the project.

 

Result in Across

As intended, the corresponding cells will not be displayed in crossDesk and consequently cannot be edited:

 

Compare it to a similar document that has been checked in without the Excel template. Correspondingly, the cells are visible: