Data Format

Soluling home Document home

Use this dialog to specify an item's format in a data structure such as a database field, an XML element, or JSON value.

Detect format on each row

If checked, Soluling detects data format on each time item is read. If you want to specify the format yourself, uncheck this.

Format

Specifies the data format. The possible values depend on the type of item.

String item

The item contains text data. The possible formats 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.

If base64, base32, base16/hex, or URL encoded binary data is selected, the dialog contains an additional combo box that specified the binary data. Look at the possible values from below.

Binary item

The item contains binary data. Binary data is used in BLOB fields of database, or base64 or hex encoded binary data in text-based files. Possible formats are:

Format	Description	Can be detected
Binary	Data contains a plain or defined binary. Plain data is not parsed but scanned as it is.	No
Text	Data contains a plain, segmented, or defined text. Plain data is not parsed but scanned as it is.	No
Script	Data contains the script of source code.	No
Image	Data contains an image.	Yes
Image list	Data contains an image list that can contain any number of images.	Yes
Audio	Data contains audio data.	Yes
Video	Data contains video data.	Yes
XML	Data contains XML data. An XML parser is used to parse the string.	Yes, if contains XML header
JSON	Data contains JSON data. A JSON parser is used to parse the string.	Most often
HTML	Data contains HTML data. An HTML parser is used to parse the string.	Yes, if contains HTML header
SVG	Data contains SVG data. An SVG parser is used to parse the string.	Yes, if contains XML header
INI	Data contains INI data. An INI parser is used to parse the string.	Most ofter
Zip	Data contains a ZIP file. The file is expanded, and each file is parsed separately.	Yes

If you select a format value, you must be sure that you select the right value. This means that the actual data must match the selected format. If you select a wrong value, an error will occur during the scanning, and Soluling can not localize the item.

Format depends on items

Depending on the selected format, the dialog can contain additional items.

Format	Description
Expression	Contains a panel that lets you enter the expression and test it.
Defined text	Contains a panel that lets you define the structured text format.
Defined binary	Contains a panel that lets you define the structured binary format.
XML	Contains a panel that lets you choose what elements to localize.
JSON	Contains a panel that lets you choose what elements to localize.
INI	Contains a panel that lets you choose what elements to localize.
HTML	Contains a panel that lets you choose what elements to localize.
SVG	Contains a panel that lets you choose what elements to localize.