Single selection :

- Translate the content of some sheets.

- Translate only the content of the active sheet.

- Translate the contents of all sheets.

Multiple selection :

- To process or not to process the notes.

- To process or not the comments in the dimensions.

- To process or not the annotations contained in the sheet format (i.e. the title block).

- Force translation. If translations are missing, it is possible to highlight them with a selected color.

- An option allows you to reprocess already translated sheets, in this case these sheets will be deleted and recreated.


Example: Highlight the untranslated elements (here in red).

 

Here is the result for a translation request in English:

 


It is possible to set up regular expressions to exclude terms from the translation.

Here are some examples of regular expressions that can be used:

  • Example detect a date in the following format: 09/12/2019

Regular expression to use =>  ([0-2][0-9]|(3)[0-1])(\/) (((0)[0-9])|(1)[0-2]) (\/)\d{4}

Explanation of the coding of this field :

            ([0-2][0-9]|(3)[0-1])(\/) (((0)[0-9])|(1)[0-2]) (\/)\d{4}

(1) (2) (3) (4) (5)

1° group the days in brackets [0-2][0-9]|(3)[0-1]

1° character : [0-2] between 0 and 2

2° character : [0-9] between 0 and 9

| or

1° character : (3) 3 only

2° character : [0-1] between 0 and 1

2nd group /

1° character only / (the preceding \ is mandatory in front of specific characters such as ' " \ /, also an ASCII or formatting code

Otherwise the character takes on another meaning in the coding of the expression.

In the case of / this means taking into account the ASCII code of the / character.

We could also have designated the ASCII code directly => \x2F.

An easy way to get the ASCII code in hexa, is to use the Windows application 'Character table'.

3rd group (0)[0-9]|(1)[0-2])

1° character : ((0)[0-9]) 0 or between 0 and 9

2° character : (1)[0-2]) 1 or between 0 and 2

4th group / (same as second)

5th groupd{4}

4 numeric characters (preceding the formatting code)


  • Example of fields:
    • Location of .txt or .zip file

([A-z0-9-_+]+\/)*([A-z0-9]+\.(txt|zip))

    • French phone number

(?:(?:\+|00)33[\s.-]{0,3}(?:\(0\)[\s.-]{0,3})?|0)[1-9](?:(?:[\s.-]?\d{2}){4}|\d{2}(?:[\s.-]?\d{3}){2})

    • Website

(http:\/\/|https:\/\/)?[a-z0-9]+([\-\.]{1}[a-z0-9]+)*\.[a-z]{2,5}(:[0-9]{1,5})?(\/.*)?


  • Etc...

You can find examples of everything you need on the internet (see Regular expression), regular expressions are used in all current programming languages.

Remember to validate your own expressions with the test tool included in DrawingTranslate.


 


Example   : Exclude all strings beginning with "130-".


 


The "Values not evaluated" tab allows you to specify properties for which the exception will not be taken into account.

For example here the notes beginning with "$PRPThese "properties" will not be taken into account for processing (e.g. property $PRPSHEET, $PRP,...).