Single selection :

- To translate the contents of certain sheets.

- To translate only the contents of the active sheet.

- To translate the contents of all the sheets.

Multiple selection :

- To process or not the notes.

- To process or not the comments in dimensions.

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

- To force the translation. So translations are missing, it is possible to highlight them with a selected color.

Example: To highlight the not translated elements (Here red).


 

Here the result for a request for translation in English language:


 


It is possible to parameterize regular expressions in order to exclude from the terms of the translation.


Here some examples of regular expressions being able to be used:

  • Example to detect a date under 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 days between brackets [0-2] [0-9]|(3) [0-1]

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

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

| or

1° character: (3) 3 only

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

2° \ group/

1° character only/(the \ which precedes is obligatory in front of the specific characters such as ‘“\/, also an ASCII coding or of formatting

If not the character takes another significance in the coding of the expression.

In the case of \/that means to take into account the ASCII code of the/character.

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

A manner simple to recover the ASCII code in hexa, is to use the application Windows ‘Character Table’

3° 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

4° \ group/(idem second)

5° \ groupD {4}

4 digital characters (\ preceding coding by formatting)


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

([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})

    • Web site

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

  • Etc…

You will find examples of all which you need on Internet (see Regular expression), the regular expressions are employed in all the current programming languages.

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


 


Example: To exclude all the chains starting with “130-“will be excluded from the translations).


 


Tab “the not evaluated Values” makes it possible to specify properties for which the exception will not be taken into account.

For example here notes starting with “$PRP“will not be taken into account for the treatment (example property $PRPSHEET, $PRP,…).