Translating special characters

We need to ensure that the labels of the combo boxes are translated if a user changes the report language. But special characters such as the colon (:) present a problem because the colon does not form part of the strings in the Table of Names and Texts.

For example, in cell B6, the label, Measure is translated if the report language is changed to German. But if we insert a colon after Measure, the string will not be translated.

The incorrect solution would be to change Measure in the Table of Names and Texts to Measure, or to have two versions of each string, one with and one without the colon.

Here is the correct solution:

  1. Use this syntax to insert labels for each of the combo boxes. Include a colon at the end of each string:
    =Translateuniquestring("Measure")&":"
  2. Use Translateuniquestring for the combo box labels.
    Note: If the strings Region, Channel etc. do not exist, you will be prompted to add them to the database. Click Yes. To specify translations for the string, select Edit > Edit Names and Texts and specify translations in the appropriate language columns.
  3. Save the report and then create a copy called Tutorial6.