GeoPoint

The 'Coordinate Delimiter' property determines the character or string that separates the latitude and longitude values when storing or displaying a geographic coordinate. This allows you to control how GeoPoint values are parsed from text and formatted for output.

Usage

• Set the delimiter to match the expected input or output format for your data.
  Common choices include a comma (","), space (" "), or semicolon (";").
• The delimiter must not conflict with the decimal separator or appear within the numeric values themselves.
• When parsing, the GeoPoint value will be split using this delimiter to extract latitude and longitude components.
• When formatting, the latitude and longitude will be joined using this delimiter.

Example:
If the delimiter is set to a comma, a value such as 34.0522,-118.2437 will be interpreted as latitude 34.0522 and longitude -118.2437.

Configuration Guidance

• Choose a delimiter that is unique and does not appear in the coordinate values.
• Ensure consistency between data entry, import, and export processes.
• If left blank, a space (" ") is used by default.

Proper configuration of the 'Coordinate Delimiter' ensures reliable parsing and formatting of geographic data in Grooper.

Can be one of the following values:

The 'Processing Mode' determines which operations are performed on values:

• Format: Values are reformatted, but not filtered.
• Filter: Values are filtered, but not reformatted.
• Both: Values are both filtered and reformatted.
• Validate: Values are only validated.

Choose the mode that best fits your data extraction and validation requirements.

The Value Delimiter property enables a Data Field to store and process multiple values as an array, rather than a single value.

• When set, the field will accept and return multiple values, separated by the specified delimiter.
• Common delimiters include , (comma), ; (semicolon), or custom strings such as | or ~~.
• Choose a delimiter that does not appear in your data values to avoid parsing errors.

Usage

• To allow a field to store multiple entries (such as a list of codes or dates), set the 'Value Delimiter' to the desired character or string.
• When the delimiter is set, the field is treated as an array, and parsing/formatting operations will split and join values using this delimiter.
• If left blank, the field will only accept a single value.

Example:
If the delimiter is ;, a value like A;B;C will be interpreted as three separate entries: A, B, and C.

The Format Specifier property controls how numeric values are formatted for display and output.

• Enter a standard or custom numeric format string, as supported by .NET.
• Use ! to disable normalization and display the raw value.
• If left blank, default formatting is applied.

Usage

• Use standard format strings (e.g., n2, c, p) for common numeric representations.
• Use custom format strings (e.g., 00000.00) for specialized output.
• For a full list of options, see the documentation for Standard Numeric Format Strings and Custom Numeric Format Strings.

Formatting Examples

> [!NOTE] > The actual output depends on the current culture settings.