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"