Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Issue
What characters can be used in a translation file?
Resolution
Translation files are comma-separated value (CSV) files. Each line of the file makes up one record, and different fields on each line are separated by commas. If the data within a field has spaces or commas, then it should be enclosed in quotes; otherwise, no quotes are needed. All characters on a standard US keyboard have been fully tested within translation files.
Note: If quotes are needed, every entry in the translation file must also be surrounded by quotes. This is an all or nothing type of situation; all entries in all columns of the translation file must have quotes. If they’re not needed, quotation marks should not be present.
Other ASCII characters are not fully tested, but there are no observed issues with any printable ASCII character. Many double-byte characters, such as UTF-8 characters, are known to cause issues and should not be used. Note that Microsoft Word and Microsoft Excel sometimes replace quotes with “smart quotes” when editing files, including CSV files. Since smart quotes are double-byte characters, these applications should not be used to edit translation files unless extreme care is taken to avoid the use of smart quotes.
Characters within the extended ASCII character set will cause issues with analysis, as will characters from the Unicode character set.
| Character | Description |
| Space | |
| ! | Exclamation mark |
| “ | Double quotes |
| # | Number/pound |
| $ | Dollar |
| % | Percent |
| & | Ampersand |
| ‘ | Single quote |
| ( | Left parenthesis |
| ) | Right parenthesis |
| * | Asterisk |
| + | Plus |
| , | Comma |
| – | Hyphen |
| . | Period |
| 0 | Zero |
| 1 | One |
| 2 | Two |
| 3 | Three |
| 4 | Four |
| 5 | Five |
| 6 | Six |
| 7 | Seven |
| 8 | Eight |
| 9 | Nine |
| : | Colon |
| ; | Semicolon |
| < | Less than |
| = | Equals |
| > | Greater than |
| ? | Question mark |
| @ | At symbol |
| A | Uppercase A |
| B | Uppercase B |
| C | Uppercase C |
| D | Uppercase D |
| E | Uppercase E |
| F | Uppercase F |
| G | Uppercase G |
| H | Uppercase H |
| I | Uppercase I |
| J | Uppercase J |
| K | Uppercase K |
| L | Uppercase L |
| M | Uppercase M |
| N | Uppercase N |
| O | Uppercase O |
| P | Uppercase P |
| Q | Uppercase Q |
| R | Uppercase R |
| S | Uppercase S |
| T | Uppercase T |
| U | Uppercase U |
| V | Uppercase V |
| W | Uppercase W |
| X | Uppercase X |
| Y | Uppercase Y |
| Z | Uppercase Z |
| [ | Left bracket |
| \ | Backslash |
| ] | Right bracket |
| ^ | Caret/circumflex |
| _ | Underscore/underbar |
| ` | Grave/backtick |
| a | Lowercase a |
| b | Lowercase b |
| c | Lowercase c |
| d | Lowercase d |
| e | Lowercase e |
| f | Lowercase f |
| g | Lowercase g |
| h | Lowercase h |
| i | Lowercase i |
| j | Lowercase j |
| k | Lowercase k |
| l | Lowercase l |
| m | Lowercase m |
| n | Lowercase n |
| o | Lowercase o |
| p | Lowercase p |
| q | Lowercase q |
| r | Lowercase r |
| s | Lowercase s |
| t | Lowercase t |
| u | Lowercase u |
| v | Lowercase v |
| w | Lowercase w |
| x | Lowercase x |
| y | Lowercase y |
| z | Lowercase z |
| ( | Left brace |
| | | Vertical bar/pipe |
| ) | Right brace |
| ~ | Tilde |
Note: Characters not present in the list above may be used if their escaped equivalents are employed.