Soluling home   Document home

Defined

Excel/CSV Field

Use this dialog to edit an array-based (e.g., Excel or CSV) definition field.

Field type

Specifies the type of the field. Possible values depend on the type of definition.

When you localize an Excel/CSV file, possible values are:

Value Description
Ignore Ignore the column.
Value The value in this field will be localized.
Context Context value. If used, each cell must contain a unique value.
Comment Row or value comment.

When you import translations from an Excel file, the possible values are:

Value Description
Ignore Ignore the column.
Import The value in this field is imported.
Context Context value. If used, each cell should contain a valid Soluling context.
Comment Row or value comment.

When you use an Excel file as a glossary, the possible values are:

Value Part of Description
Ignore - Ignore the column
Entry id Entry Id of the entry
Definition Entry Definition of the entry
Subject field Entry Subject of the entry
Term id Term Id of the term
Term value Term Term value
Term description Term Description of the term
Term location Term Location of the term
Term type Term Type of the term
Part of speech Term Part of the speech of the term
Grammatical gender Term The grammatical gender of the term

Data type

Specifies the data type of the field. Possible values are:

Format Description
Plain text String contains plain text.
Segmented text String contains the segmented text.
Boolean String contains a boolean value. 1/0, true/false, and yes/no are valid values.
Integer number String contains an integer number.
Floating point number String contains a floating-point number. It can be in scientific format (e.g., 1.45E-12). The decimal separator (if any) must be a period (e.g., 1.5).
Color

String contains a color value. Possible formats are [#|$|0x][AA]RRGGBB or [#|$|0x][A]RGB.

Date and time

String contains a date and time value. ISO 8601 (Wikipedia) must be used.

Expression String contains a structured string that is defined using an expression. Regular expressions are used to parse the string.
Defined text String contains the defined text. A text definition (using regular expressions) is used to parse the string.
Script String contains script data. A script/source code parser is used to parse the string.
XML String contains XML data. An XML parser is used to parse the string.
JSON String contains JSON data. A JSON parser is used to parse the string.
YAML String contains YAML data. A YAML parser is used to parse the string.
INI String contains INI data. An INI parser is used to parse the string.
HTML String contains HTML data. An HTML parser is used to parse the string.
SVG String contains SVG data. An SVG parser is used to parse the string.
Base64 encoded binary data String contains base64 encoded data. Encoded data is decoded into original binary data and scanned.
Base32 encoded binary data String contains base32 encoded data. Encoded data is decoded into original binary data and scanned.
Base16/hex encoded binary data String contains base16/hex encoded data. Encoded data is decoded into original binary data and scanned.
URL encoded binary data String contains URL encoded data. Encoded data is decoded into original binary data and scanned.

Language

Specifies the language of the field.

Value index

Specifies the index of that field where this comment field belongs to. Used only with comment fields.

Encoding

Specifies the character encoding used in the field.

Special characters have been escaped

Check this if the special characters (e.g., line feed, carriage return) in the strings of the file have been escaped using C/C++ strings escapes.

Name

Specifies the name of the field. This is optional and is used to just give a friendly name for the field.

Quote

Specifies if the value has been quoted. Possible values are:

Value Description
None Value is not quoted. For example, Car
Single Value is quoted with single quotes. For example, 'Car'
Double Value is quoted with double-quotes. For example, "Car"