Additional settings are available for each format.
CSV-Format-Specific Settings
The database can be created in Excel as a two-column Excel document and saved as a CSV file. Set the following settings depending on the design of the Excel document:
1.Line Breaks
Select the desired coding for the line break:
–Windows (CRLF)
–Unix (LF)
2.Encoding
Select the desired character encoding:
–UTF-8
–ISO 8859-1
The standard settings (Windows, ISO-8859-1) can be used to work in Excel with Windows.
3.Separator Character
Select the separator used in the CSV file:
–Comma (',')
–Semicolon (';')
4.Columns
Enter the column numbers from which the CSV file is read:
Source Column (here: column 0 in the CSV file)
Target Column (here: column 1 in the CSV file)
You can use RegEx to search for columns that contain terms such as German or English in the column header.
You can use RegEx. The icon 
opens the RegEx Editor.
5.Ignore
If you explicitly work with brackets in the CSV file, you can explicitly exclude the brackets with content from being used in the target parameter, e.g. if it is specified after a translation that it is only used in the singular: {sg}. In this case, activate the Ignore text in curly brackets checkbox to prevent this information from being written to the target parameter.
The following characters can be ignored:
–Ignore text in brackets
–Ignore text in square brackets
–Ignore text in curly brackets
JSON-Format-Specific Settings
You can access translations in JSON format. Set the following settings depending on the design of the JSON files:
1.Behavior for multiple values
If several translations are possible for a value, select the principle according to which the translations are applied.
Take the first value
Take the last value
2.File Structure
Select the file structure of your JSON dictionary:
–Single Dictionary
Pairs of word and translation are stored. Each value only occurs once, e.g.
{
"Hello World": "Hallo Welt",
"Apple": "Apfel"
}
–List of JSON Objects
Pairs of word and translation are stored. By formatting with square brackets, it is possible to store several translations for one word, e.g.
[
{
"Name": "Hello World",
"Value": "Hallo Welt"
},
{
"Name": "Apple",
"Value": "Apfel"
}
]
–Dictionary of Dictionaries
Translations for several languages can be stored, e.g.
{
"English->Deutsch": {
"Hello World": "Hallo Welt",
"Apple": "Apfel"
},
"English->русский язык": {
"Hello World": "Здравствуй мир",
"Apple": "яблоко"
}
}
SQLite-Format-Specific Settings
You can access SQLite databases. Set the following settings depending on the design of the SQLite database.
Select value from a fixed table
If you select the Select value from a fixed table option under SQL search mode, you can specify the details from this table as follows:
1.Table Name
Enter the name of the table from which the values are to be read.
2. Source Column Name
Enter the column number of the source column.
3. Target Column Name
Enter the column number of the target column.
Custom SQLite Query
If you select the Custom SQLite Query option under SQL Lookup Mode, you can create a query that queries values from one or more tables.
1.Text field for entering the query
A query can look like this, for example: SELECT german FROM dictionary_table WHERE english = ?;
With this query, you select the values in the English column from a specific dictionary.
